Activity 11: Learn the GROUP BY command
Workshop Resources
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.
What the 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 COUNT() and GROUP BY commands to show the number of cities that like each food.
(Review activity 3 and activity 4 for help)
Type command here!
ERROR INVALID INPUT>
You did it Space Cadet! Now the inhabitants can finally begin the party!
✓
You've completed the task! Continue to the next mission!