Show the total number of bowlers that live in bethell

Assignment Help Business Management
Reference no: EM13737316

Show the total number of bowlers that live in Bethell, WA.

Display the number of games won in match 14, game 2. Rename the resulting data column WINNERS.
Show the number of games that the bowler with bowlerID 8 has won thus far.
What is the total raw scores of all bowlers who played in match 13, game 3?

Display the total handicap scores of the bowler that has a BowlerID of 18 for all matches and games. Rename the result column Total Handicap.
Show the average of all raw scores of games lost in match 19. Note: the WonGame field is a Boolean value, therefore 0 represents a lost game, and 1 represents a game that was won.

Display the largest handicap score of games won in match 20, game 2. Note: the WonGame field is a Boolean value, therefore 0 represents a lost game, and 1 represents a game that was won.

Show the most recent tournament date in the bowling league schedule. Rename the resulting column Last Tournament Date.

Display the raw scores of the games that are less than the average of all raw scores of games lost in match 20, game 1. Note: the WonGame field is a Boolean value, therefore 0 represents a lost game, and 1 represents a game that was won. You will use a subquery to retrieve this data. See p. 434 in your textbook.

Display how many tournaments have been played at Sports World Lanes. Rename the result column Number of Tournaments.
Part 2 

Directions: After reviewing and completing the Unit 3 Guided Practice 1, create five scenarios using the following SQL syntax, clauses, and keywords.

Each scenario must include a select clause.
You need to include the where clause in at least two scenarios.
You need to use at least three of the following aggregate functions: COUNT(), SUM(), AVG(), MIN(), MAX()
You also need to include one scenario that includes using aggregate function using filters as described on p. 432 in the textbook.
Lastly, you will need to rename at least one resulting field in your result data set using the AS keyword.
**Feel free to include any other functions that you have learned in the guided practice exercises or previous SQL syntax to expand your learning experience.
You may use any of the Bowling League tables or the Demo_CUSTOMERS/ORDERS/PRODUCTS tables in your Oracle account. Be sure to list the scenario, include the SQL syntax that retrieves the data, and include a screenshot of your result data sets. 

After you are finished, please submit the Microsoft Word file that contains Part 1 and Part 2 of your assignment. Your document should be named U3_Assignment1_Lastname.docx. Submit your file using the Upload Instructions below. 

Verified Expert

Reference no: EM13737316

How culture and diversity can and do affect all managers

Conduct a web search seeking two examples where you believe the organization embraced multiculturalism and diversity and was able to create an open and thriving work environ

American capitalism and business ethics

Is it unfair to increase a CEO's compensation at the same time that he or she downsizes the workforce? What is an ethically justifiable way to determine the pay of a CEO of

Equals method and returns true

Write a generic method that compares its 2 arguments using the equals method and returns true if they are equal and false otherwise. Ensure that the name of your method incl

Income tax system nor imports goods

Suppose real GDP in the economy has decreased by $25 billion. This economy has neither an income tax system nor imports goods and services. Therefore, by how much must auton

Question regarding the persuasive letter

Choose a person from your own life to address in a letter. Write that person a 700- to 1400-word persuasive letter explaining how theology and philosophy are different. Use

Monthly mortgage payment be for the principle and interest

With interest rates at 4.875% for a 30-year fixed mortgage, Dan, age 48, plans to buy a house for $825,000. He wants to put half of the purchase price down. What will his mo

Determining the benefits of daily life

In many churches today there is a debate over the legitimacy of homosexual unions. Do you think religions have an impact on the costs and benefits people face in day to day

Roles of hr in career management

Prepare 2 different reports (each of 800 words) on the roles of HR in career management. NO copy material from internet sources or student paper will be accepted. material w

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd