QL 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$)$:

Use the e$\_$store database

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\mathrm{.}01$ sec$)$

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\mathrm{.}00$ sec$)$

Once you have completed these tasks press the Check It$!$ button to have your solution assessed.

Check It$!$