Activity 1: Learn the SELECT Command

Workshop Resources

Mission 1: Save the Planet of Fun from Boredom!

Your first mission is to go to the Planet of Fun and save them from boredom! You are sent a database about the planet and you need to learn how to use SQL commands to help save the Planet of Fun!

Task 1: Take a peek at the information on the Planet of Fun

You are given information about the Galaxy and want to look for the Planet of Fun. To do this, the Galactic Federation has given you your first SQL command: SELECT.

What the command does:

The SELECT command allows you to choose what data to show from a database.



Now use what you learned!

Drag the blocks into the terminal and rearrange them to answer the question below!

Question: What command will display all the columns in the database called “galaxy”?