MySQL SQL MIN() A sql-6-1.sql file has been opened for you. Write each of the fo

Question

MySQL

SQL MIN()

A sql-6-1.sql file has been opened for you.

Write each of the following tasks as a SQL statement in a new line:

Select the product with the least stock from the e_store.products table. The output should look like this:

Select the product with the least stock from the e_store.products table aliasing the column name as: min_stock. The output should look like this:

Select the product with the least stock from the e_store.products table where the id is greater than 3. Alias the column name as: min_stock. The output should look like this:

Explanation / Answer

The following are the SQL queries for the requirements in the instructions. It would have helped if you could have provided the table structure of the products table. It can help confirm the name of the "id" column.

If you have any changes or questions, please revert to me.

select MIN(stock) from e_store.products

select MIN(stock) as min_stock from e_store.products

select MIN(stock) as min_stock from e_store.products where id > 3

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.