The Whole Courses Table

Show every column of every course without typing out the column names. The courses table has eleven columns and fourteen rows, and your result should contain all of them.

Expected result:

+----+---------+-----------------------------+---------------+---------------+---------+-------+-----------+-------+-------------+-----+
| id | code    | title                       | department_id | instructor_id | credits | level | max_seats | room  | semester    | fee |
+----+---------+-----------------------------+---------------+---------------+---------+-------+-----------+-------+-------------+-----+
|  1 | CS101   | Introduction to Programming |             1 |             1 |       3 |   100 |        60 | T-100 | Fall 2025   | 650 |
|  2 | CS201   | Data Structures             |             1 |             2 |       3 |   200 |        40 | T-102 | Winter 2026 | 650 |
|  3 | CS230   | Databases                   |             1 |             3 |       3 |   200 |        35 | T-104 | Winter 2026 | 700 |
|  4 | CS310   | Operating Systems           |             1 |             1 |       4 |   300 |        30 | T-106 | Fall 2025   | 820 |
|  5 | MATH110 | Calculus I                  |             2 |             4 |       4 |   100 |        80 | G-001 | Fall 2025   | 600 |
|  6 | MATH220 | Linear Algebra              |             2 |             5 |       3 |   200 |        45 | G-010 | Winter 2026 | 600 |
|  7 | ENG101  | Academic Writing            |             3 |             6 |       3 |   100 |        50 | A-110 | Fall 2025   | 450 |
|  8 | ENG250  | Modern Literature           |             3 |             7 |       3 |   200 |        30 | A-204 | Winter 2026 | 450 |
|  9 | BIO120  | Cell Biology                |             4 |             8 |       4 |   100 |        70 | D-050 | Fall 2025   | 720 |
| 10 | BIO305  | Genetics                    |             4 |             9 |       3 |   300 |        25 | D-210 | Winter 2026 | 780 |
+----+---------+-----------------------------+---------------+---------------+---------+-------+-----------+-------+-------------+-----+
(showing 10 of 14 rows)

Hints2 available

Topics:

SELECT Basics

Code Editor

Tab to indent (Esc then Tab to move on) · Ctrl+Enter to run · Ctrl+Space to expand shortcuts (sel, ins, desc)

Results

Run your SQL to see every statement's output here, then how it compares with the expected answer.

Not sure what is in a table? SHOW TABLES lists them and DESCRIBE students shows the columns — or open the database browser on the left.