Courses Worth the Most Credits

Find the courses that carry the highest credit weight on offer, without writing the number yourself. Return code, title and credits, sorted by code. Three courses tie for the top, and all three must appear.

Expected result:

+---------+-------------------+---------+
| code    | title             | credits |
+---------+-------------------+---------+
| BIO120  | Cell Biology      |       4 |
| CS310   | Operating Systems |       4 |
| MATH110 | Calculus I        |       4 |
+---------+-------------------+---------+
3 rows

Hints3 available

Topics:

Subqueries

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.