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
Get step-by-step solutions from verified subject matter experts
