CJCoding With Joseph
15free / daySign inCreate account

Course Titles Ending in -ing

Return the code and title of every course whose title ends with the letters ing, sorted alphabetically by title. Five courses match.

Expected result:

+--------+-----------------------------+
| code   | title                       |
+--------+-----------------------------+
| ENG101 | Academic Writing            |
| BUS320 | Financial Accounting        |
| CS101  | Introduction to Programming |
| BUS150 | Principles of Marketing     |
| CS350  | Software Engineering        |
+--------+-----------------------------+
5 rows
Hints3 available
Topics:
SELECT Basics
1
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.