EssayNICE | 24/7 Homework Help

MySQL

Output reference challenge

This challenge has an output reference, meaning that the SQL queries you write in the *.sql file must output the same result if you source it.

For these kind of challenges, there is a terminal tab enabled in the left pane so you can:

1. Write down the tasks in the file
2. source the file in the mysql> command line by executing source sql-6-*.sql
3. Compare the output of your input file against the reference output
4. If the result matches, Check it! afterwards

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:

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

+————+