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. Let's zoom in on this table in the database schema to see the fields and data types it contains.

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

books table fields and datatypes

Instructions 1/3

undefined XP
  • 1
    • Use SQL to return a result set of all book titles included in the books table.
  • 2
    • Select both the title and author fields from books.
  • 3
    • Select all fields from the books table.