Question: id | name | price | stock | created_at | +----+------------+--------+-------+---------------------+ | 1 | Tablet | 145.50 | 8 | 2015-10-09 00:49:30 | | 2

id | name | price | stock | created_at | +----+------------+--------+-------+---------------------+ |

1 | Tablet | 145.50 | 8 | 2015-10-09 00:49:30 | | 2 | Smartphone | 90.80 | 9 | 2015-10-28 04:43:05 | | 3 | PC | 157.40 | 1 | 2015-10-10 18:13:09 | | 4 | Headphones | 20.00 | 6 | 2015-10-30 06:30:30 | | 5 | Speakers | 56.89 | 4 | 2015-10-27 12:24:56 | | 6 | Monitor | 125.45 | 7 | 2015-10-22 11:32:53 | +----+------------+--------+-------+---------------------+

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.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.00 sec)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!