Activity 11: Learn the GROUP BY command
Party with the Inhabitants!
You are tasked to choose which food to serve at the party! Each city has their own favorite food and you need to decide which ones to have at the party! Let’s use the
GROUP BY command to figure out what to bring.
GROUP BY command does:
Task 11: Using the database called ‘planet’ with the column ‘favorite_food’, find out what to bring to the party!
Hint: The command follows closely to the example above.
BONUS: Combine the
GROUP BY commands to show the number of cities that like each food.
(Review activity 3 and activity 4 for help)