Workspace
Bashir Abdulraheem/

Introduction to SQL

0
Beta
Spinner

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.).

Take Notes

Add notes about the concepts you've learned and SQL cells with queries you want to keep.

Add your notes here

Unknown integration
DataFrameavailable as
books
variable
-- Add your own queries here
SELECT * 
FROM books
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.

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.
Unknown integration
DataFrameavailable as
df
variable
-- Select only the `title` column.
SELECT title
FROM books;
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
df1
variable
-- Alias the `title` column as `book_title`.
SELECT title AS book_title
FROM books;
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
df2
variable
-- Select the distinct author names from the `author` column.
SELECT DISTINCT author
FROM books;
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
df3
variable
-- Select all records from the table and limit your results to 10.
SELECT *
FROM books
LIMIT 10;
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
df4
variable
SELECT COUNT(id) AS count_record
FROM books;
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
df5
variable
SELECT COUNT(*) AS cont_record
FROM books;
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
df6
variable
SELECT *
FROM books
WHERE id IS NULL;
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
df7
variable
SELECT 
	author,
	COUNT(title) AS count_title
FROM books
GROUP BY author
HAVING COUNT(title) >= 2
ORDER BY count_title
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
df8
variable
SELECT year, author, COUNT(title) AS no_of_release
FROM books
GROUP BY author, year
HAVING COUNT(title) > 2
ORDER BY no_of_release
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
  • AI Chat
  • Code