4.3 - Write each of the following tasks as a SQL statement in a new line: Select
ID: 3907800 • Letter: 4
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;