SESSION NAME: SQL Functions - 1.
QUESTION NAME: Minimum Tents.
TABLE DESCRIPTION:
For all of the tents that were ordered in the items_ordered table,
what is the price of the lowest tent?
Hint: Your query should return the price only.
Note: Use SQL in-built Function to calculate minimum
value in tents.
what is the price of the lowest tent?
Hint: Your query should return the price only.
Note: Use SQL in-built Function to calculate minimum
value in tents.
CODE:
select min(price) from items_ordered where item='tent';
0 Comments