1. Learn
  2. /
  3. Courses
  4. /
  5. Introduction to SQL

Connected

Exercise

Querying the books table

You're ready to practice writing your first SQL queries using the SELECT and FROM keywords. Recall from the video that SELECT is used to choose the fields that will be included in the result set, while FROM is used to pick the table in which the fields are listed.

Feel free to explore books in the exercise.

Your task in this exercise is to practice selecting fields from books.

Instructions 1/3

undefined XP
  • 1
    • Select the title from the books table to view all book titles.
  • 2
    • Select both the title and author fields from books.
  • 3
    • Select all fields from the books table.