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

Question

4.3 - 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

1. SELECT MIN(stock) FROM e_store.products; 2. SELECT MIN(stock) as min_stock FROM e_store.products; 3. SELECT MIN(stock) as min_stock FROM e_store.products WHERE id > 3;

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

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