Skip to content

Introduction to SQL

Here you can access the books table used in the course.

Note: When using sample integrations such as those that contain course data, you have read-only access. You can run queries, but cannot make any changes such as adding, deleting, or modifying the data (e.g., creating tables, views, etc.).

Spinner
DataFrameas
books
variable
-- Add your own queries here
SELECT * 
FROM books

Explore Datasets

Use the books table to explore the data and practice your skills!

  • Select only the title column.
  • Alias the title column as book_title.
  • Select the distinct author names from the author column.
  • Select all records from the table and limit your results to 10.
Spinner
DataFrameas
df1
variable
-- Select unique authors and genre combinations from the books table
SELECT DISTINCT author,genre
FROM books;
Spinner
DataFrameas
df2
variable
-- Alias author so that it becomes unique_author
SELECT DISTINCT author AS unique_author
FROM books;
Spinner
DataFrameas
df
variable
-- Save the results of this query as a view called library_authors
CREATE VIEW library_authors AS
SELECT DISTINCT author AS unique_author
FROM books;
Spinner
DataFrameas
df3
variable
-- Your code to create the view:
CREATE VIEW library_authors AS
SELECT DISTINCT author AS unique_author
FROM books;

-- Select all columns from library_authors
SELECT * FROM library_authors;
Spinner
DataFrameas
df4
variable
-- Select the first 10 genres from books using PostgreSQL
SELECT genre
FROM books
LIMIT 10 ;