Multiple choice

Consider the following database table- Table Name- Items_Ordere |||||| |---|---|---|---|---| |Customer_ID|Order_date|Item|Quantity|Price| |77120|6-Jul-1999|Belt|1|140| |77121|1-Jul-1999|Watch|4|1230| |77122|30-Jun-1999|T-shirt|6|1020| |77123|12-June-1999|Fan|1|950.50| |77124|30-Aug-1999|Cooler|1|4010.20| |77125|30-May-1999|Bag|7|2950| |77126|1-Jun-1999|Shoes|2|1280| |77121|3-Sep-2000|Watch|5|1800| |77125|12-Feb-2001|Jeans|6|4050| |77122|12-Feb-1999|Jeans|2|2000| |77124|1-Aug-2000|Jacket|1|1260|

Display the maximum and mimimum price of each specific item, if the price that item is more than 1500. Select the correct option.

  1. Select item, max(price), min(price) from items_ordered group by item where max(price)>1500

  2. Select max(price), min(price) from items_ordered group by item having max(price)>1500

  3. Select item, max(price), min(price) from items_ordered group by item having max(price)>1500

  4. Select item, max(price), min(price) from items_ordered group by item having count(price)>1500

  5. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is the correct SQL statement to display the desire output.

Keep practicing — related questions