id | name | price | stock | created_at | +----+------------+--------+-------+---
ID: 3850010 • Letter: I
Question
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)
Explanation / Answer
SELECT SUM(stock) AS total_stock FROM e_store;
SELECT id,SUM(stars) as total_stars where id=4;
Note : The above table haven't had 'stars' column. If the second Question was typo mistake please replace stars with 'stock'
Thank you.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.