Reference no: EM13906427
Using Unit 1 Bowling League database
Create a New MS Word document and Save it as: U3_Assignment1_Lastname
For all of the scenarios below, write the question numbered followed by the SQL SELECT syntax (copy & paste) and a screen shot of the SQL Select with results from SQL Server
Use the syntax:
SELECT ...
FROM ...
WHERE …
ORDER BY ….
Aggregate Functions – all of the following Select statements must use a function
Show the total number of bowlers that live in Bothell, WA (hint: How many?)
Show the number of games that the bowler with bowler ID 8 has won thus far.
What is the total raw scores of all bowlers who played in match 13, game 3? (hint: add the scores)
Display the total handicap scores of the bowler that has a Bowler ID of 18. Rename the result column Total Handicap.
Show the most recent tournament date in the bowling league schedule. Rename the resulting column Last Tournament Date.
Display how many tournaments have been played at Sports World Lanes. Rename the result column Number of Tournaments.
Aggregate Functions, Grouping Data (GROUP BY & HAVING)
Display the bowler's ID and the average raw score for each bowler. Sort the results by the average raw score in descending order.
Calculate the total raw score (add the scores) for each bowler. Display the bowler’s ID and total raw score. Rename the total raw score as Total Pins.
Display match ID and the highest raw score for each match. Only display the results for bowlers who have a high raw score more than 193.
Display the match id, game number and the average handicap score per match and game. Only show results for average handicap scores less than 185. Rename the average score result set Average Under 185. In the results, concatenate the match id and game numbers into one column, include the literal comma, and literal text “Match ID” and “Game Number” as shown in the sample results below:
(No Column Name) Average Under 185
Match ID 12, Game Number 1 183
Match ID 39, Game Number 2 184
|
Fzp pharmaceutical company has a published mission statement
: FZP Pharmaceutical Company has a published mission statement which refers to its commitment to act in a socially responsible manner. At a recent Board meeting the ChiefExecutive presented a number of proposals outlining what she thinks the company sh..
|
|
What level should it set these charges
: Assuming the phone company has to charge the same monthly rental fee and unit price to all its customers, at what level should it set these charges?
|
|
How much amortization expense on goodwill can ingrid deduct
: How much amortization expense on the goodwill can Ingrid deduct in year 1, year 2, and year 3? In lieu of the original facts, assume that Ingrid purchased only a phone list with a useful life of 5 years for $10,000.
|
|
What pauls allowable macrs depreciation expense for property
: What is Paul's allowable MACRS depreciation expense for the property? What is Paul's allowable alternative minimum tax (AMT) depreciation expense for the property?
|
|
Match id and game number
: Calculate the total raw score (add the scores) for each bowler. Display the bowler’s ID and total raw score. Rename the total raw score as Total Pins. Display match ID and the highest raw score for each match. Only display the results for bowlers wh..
|
|
The pst appreciates relative to the eur
: In the following problem, assume that the UK currency is the pound sterling (PST) and the currency in the rest of the Europe is the euro (EUR).Suppose that the PST appreciates relative to the EUR. For the following parts, you will not receive any cre..
|
|
Summarize the creation of federal labor policy
: Summarize what you learned from our reading material. What did you find most interesting? Why? How will it help you as a professional. Support your thoughts with material from our text and outside sources.
|
|
What is the marginal propensity to consume
: If equilibrium output rises by a total of $400 billion in response to an increase in government spending of $80 billion, what is the marginal propensity to consume? (the answer in .8 but I need an explanation on how/why)
|
|
Nsa company produces baseball bats
: NSA Company produces baseball bats. Each bat requires 3 pounds of aluminum alloy.
|