SQL Module

Open a SQL assignment

When you open a SQL assignment, you'll see an overview panel on the left that explains the database structure and lists the specific queries you need to write. The main area displays instructions for each query, such as finding all books or calculating revenue per author. Click "Open SQL Editor" at the bottom right to start writing your SQL code for each question.

Explore the database schema

The left sidebar displays the database structure for a bookstore, showing three main tables: authors, books, and sales. Each table lists its columns with data types (like INTEGER for numbers, TEXT for words) and shows the relationships between tables through foreign keys (indicated by the orange "FK→" labels). This schema view helps you understand how the data is organized before writing SQL queries to retrieve information from the database.

Write and run a query

The query editor area is empty and shows "Query executed. No results returned." because no SQL query has been written yet. You can see the database schema on the left side showing three tables (authors, books, and sales) with their column names and data types. To get started, type your SQL query in the editor area above the results section, then click the "Run" button to execute it.

Use multiple tabs

Reset the database

Submit your SQL work