Courses Not Worth Three Credits

Most courses are worth 3 credits. Return the code, title and credits of every course whose credits value is anything other than 3.

Expected result:

+---------+----------------------+---------+
| code    | title                | credits |
+---------+----------------------+---------+
| CS310   | Operating Systems    |       4 |
| MATH110 | Calculus I           |       4 |
| BIO120  | Cell Biology         |       4 |
| ART140  | Drawing Fundamentals |       2 |
+---------+----------------------+---------+
4 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.