MySQL

SUM() and COUNT()

A sql-6-11.sql file has been opened for you.

Write the following task as a SQL statement in a new line (remember that you can source the file to compare the output reference):

1 - Select the total stock and the total products from the e_store.products table in a single query. Alias the result as total_stock and total_count respectively. The output should look like this:

+-------------+----------------+ | total_stock | total_products | +-------------+----------------+ | 35 | 6 | +-------------+----------------+ 1 row in set (0.06 sec)