Answered step by step
Verified Expert Solution
Question
1 Approved Answer
MySQL SQL 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
MySQL
SQL 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):
1 - Use the e_store database
2 - 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)
3 - 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started