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!