Question
1. Bowling League - Show me the list of tournaments. For each tournament, I want the ID and location. Sort it by location (20 rows)
1. Bowling League - Show me the list of tournaments. For each tournament, I want the ID and location. Sort it by location (20 rows)
2. Entertainment Agency - How many customers are there? (1 row, with value 15)
3. Show the list of measurements. For each measurement, show the measurement name (26 rows)
4. Show a list of products with more than 20 on hand. For each product, show the product number, name, retail price and quantity on hand (14 rows)
5. School Scheduling - Show me a list of students from Texas (3 rows)
For each one, turn in the following, The SQL query (a file with .sql extension) The results of running the query, a csv file. This should be exported from the result grid in MySQL Tips: To get the number of rows, use the count() function, such as "select count(*) from Ingredients" To test whether a string contains a certain word, use a condition such as "where ingredientname like '%chicken%'"
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