Aggregate Functions
Outcomes
Use SQL to retrieve database information
Problems
1. How many Ford vehicles are there? (Remember the LIKE operator)
2. What is the highest price for a service?
3. What is the lowest price for a service?
4. What is the average price for a service?
5. Although it doesn't make much sense, what it the total of all the service prices?
6. What is the count of cars served in each location?
7. list only the locations and counts of those locations that have served more than 15 customers
8. How many employees does each supervisor supervise?
9. What is the count of vehicles served on the first of March 2010?
10. What is the total number of vehicles served per month?
What I am looking for
I want to see the SQL that would answer each problem. I do not need to see the actual answers, though you can include them if you wish
Each problem is worth 1 point for a total of 10 points
What to turn in
Paste your answers into a Google doc and share it with spconger@gmail.com
No comments:
Post a Comment