Question
Answer each question by pasting in your SQL solution from the query tool. We just need the SQL query text.Answers will be revealed after the
Answer each question by pasting in your SQL solution from the query tool. We just need the SQL query text.Answers will be revealed after the assignment closes.
1. PetStore: List all of the fish sorted by breed
2. PetStore: List all animals born in March
3. PetStore: What is the total value of all dog related merchandize
4. PetStore: What is the largest merchandise quantity on hand. Show a single row result.
5. PetStore: List all of the cities in Arizona with population 1990 great than 10000 organized by zipcode
6. PetStore: For each zipcode calculate the total population of cities in New York (using population 1990)
7. PetStore: How many animal friends does the PetStore have. Hint - See Employee table.
8. PetStore: Who is the newest employee. Hint - Organize by date hired and limit results to one row
9. RollingThunder: What is the profit margin for derailleurs for Road bikes listed highest to lowest. Search for derailleur in any part of the description. The profit margin is the list price minus the estimated cost
10. RollingThunder: What is the greatest number of components ever installed in one day by one employee. Ignore employee 0 (which means none). Rank from largest to smallest. Hint - Use bike parts table.
11. What is the average sale price of bicycles sold in California in 2013
12. RollingThunder: What is the largest discount percent given on mountain bikes (including full) bicycles sold in Oregon in 2007. The discount can be calculated as the (list price less the sale price) divided by list price
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started