INNER JOIN in SQL

SQL interview exercise on Joins, difficulty 1 of 3. Solve it in the editor beside a worked example; the tests run the moment you do.

Show every order line with its product's name. Columns: order_id, product, quantity. Sorted by order_id, then product.

Each exercise pairs a worked example with a twin problem to solve in a real editor; the tests run the moment you do. Progress is saved in your browser, and in your account if you sign in.

More Joins in SQL

All SQL exercises ยท Other languages and frameworks