Pick the Columns You Want

You’ve seen how to retrieve an entire table with SELECT *. Now let’s get specific: you’ll learn how to query only the columns you need.

Goal

You’ll aim to:

• Select specific columns using SELECT column_name.

• Clean up your output.

Tables

Let’s use the following table in this lesson:

The people table