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%'"