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

Previous Q& A

  What is first seasonal difference value of the data series

Which is the appropriate ARIMA menu for the model given the non seasonal and seasonal menu form - What is the first seasonal difference value of the data series?

  Explain how statistical analysis is utilized

In your paper, explain how statistical analysis is utilized in quality control/assurance. Why is knowing statistical analysis an important skill to learn for managers and leaders

  What ethical issues involved in marketing to children

What are the ethical issues involved in marketing to children in this manner

  What precisely did the civil right movement gain

What precisely did the Civil Right Movement gain? What objectives did it fail to achieve? How were the approaches of Martin Luther King Jr, and Malcom X to Civil Rights different? How were they the same?

  What is the highest expense for business materials

What is the highest expense for business materials? How can managers monitor and keep this cost as low as possible? Explain.

  Fdi flows will be on national and regional economies

Step back from all this and tell me what you think the long-term consequences of the incoming and outgoing FDI flows will be on national and regional economies, and also on the political construct of many of the nations we trade with. For example,..

  Provide a total cost summary

Build your cost model but calculate labor, equipment depreciation, material, and facility costs separately. Then provide a total cost summary.

  Defining the project scope

Review the project case. Determine the scope of the District 4 Production Warehouse Move project from the information provided in the case. Using the Project Scope Checklist, prepare a scope document for review and approval by the project sponsor ..

  Write an essay on statue of an offering bearer

The analysis of Statue of an Offering Bearer should begin with an introduction of the artwork that includes the title, date, medium (material from which it is made), and the museum in which it is located.

  Project team and stakeholder management

As the project manager for the District 4 Warehouse Move project, you will need to determine who your stakeholders and project team members are for this project.

Reviews

Write a Review

 

Similar Q& A

  By using the irac method

By using the IRAC method- Sally and Tom choose to go into business selling discounted merchandise through their website e-buy

  International industry conference on social networkingas

international industry conference on social networkingas part of your research you attend an international industry

  Managing risk for a publicly traded companyif you work for

managing risk for a publicly traded companyif you work for a publicly traded company download the companys annual

  Research design and statistical information

How do research design and statistical information affect validity?

  Subcultures in organizationswe may know a bit about the

subcultures in organizationswe may know a bit about the culture of an organization by observing it but what about the

  Define how this strategy helps klimpton make supplier

Define how this strategy helps Klimpton make supplier channel decisions as well as manage the waste from its hotel and restaurant operations.

  Illustrate what workers would be classified as direct labour

Illustrate what workers would be classified as direct labour. Illustrate what workers would be classified as indirect labour.

  Categorize the employees into groups

Corporate Communication- Categorize the employees into five groups. Specify the reasons for this categorization.

  What is the personnel selection process

What is the personnel selection process? Explain the legal standards for personnel selection. The four kinds of interviewing techniques.

  Consider recent events and the prevailing politicak

Consider recent events and the prevailing politicak and economic conditions in the Russian Federation. As a manager who has been considering investment there, how do you assess the political and economic risks

  Explain which type of organizational communication it is

She has a one-hour meeting through her staff to explain the new claim form which the company will use next month. This is an example of which type of organizational communication.

  Who controls health care

Who controls health care?

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