1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to SQL
Connected

Exercise

Making queries DISTINCT

You've learned that the DISTINCT keyword can be used to return unique values in a field.

The books table contains 350 books, representing all of the books that our local library has available for checkout.

But how many different authors are represented in these 350 books?

Instructions 1/2

undefined XP
  • 1
    • Select only the unique authors from the books table.
  • 2
    • Update the code to return the unique author and genre combinations in the books table.