COUNT and SUM in SQL

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

Return one row with the number of products and the total units in stock. Columns: products, total_stock.

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 Aggregation in SQL

All SQL exercises ยท Other languages and frameworks