MySQL

SQL SUM()

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

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

1 - Use the e_store database

2 - Select the total stock of all products in the products table. Alias the column name as total_stock. The resulting table should look like this:

+-------------+ | total_stock | +-------------+ | 35 | +-------------+ 1 row in set (0.01 sec) 

3 - Select the total stars of the product with id = 4. Alias the column name as total_stars. The resulting table should look like this:

+----+-------------+ | id | total_stars | +----+-------------+ | 4 | 7 | +----+-------------+ 1 row in set (0.00 sec)