Skip to content
Introduction to SQL
  • AI Chat
  • Code
  • Report

    • Introduction to SQL

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

    Spinner
    DataFrameavailable as
    books
    variable
    --Select only the `title` column.
SELECT title
FROM books;

--Alias the `title` column as `book_title`.
SELECT title AS book_title
FROM books;

--Select the distinct author names from the `author` column.
SELECT DISTINCT author
FROM books;

--Select all records from the table and limit your results to 10.
SELECT *
FROM books
LIMIT 10;