MySQL

SQL COUNT()

A sql-6-6.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 amount of products in the products table. Alias the column name as total_product_count. The resulting table should look like this:

+---------------------+ | total_product_count | +---------------------+ | 6 | +---------------------+ 1 row in set (0.01 sec) 

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

+----+--------------------+ | id | stars_fields_count | +----+--------------------+ | 4 | 2 | +----+--------------------+ 1 row in set (0.00 sec)