1. Learn
    2. /
  2. Courses
    3. /
  3. SQL Tutorial for Marketers

Exercise

SELECTing Data

In the real world, you will often want to select multiple columns. Luckily, SQL makes this really easy. To select multiple columns from a table, simply separate the column names with commas!

For example, this query selects two columns, age and loan, from the clients table:

SELECT age, loan
FROM clients;

Now that you know this, you know enough to tackle the tasks below!

Remember, you can see the results of executing your query in the query result tab to the right!

Instructions 1/3

undefined XP
  • 1

    Select all data from the clients table.

  • 2

    Select only the age, job, marital, education columns from the clients table.

  • 3

    Select the first 50 rows of the campaigns data