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

Calculate the average price of all of the items ordered that were purchased in the month of June. Select the correct option.

  1. SELECT avg(price) FROM items_ordered WHERE order_date '%Jun%';

  2. SELECT avg(price) FROM items_ordered WHERE order_date LIKE '%Jun%';

  3. SELECT avg(price) FROM items_ordered WHERE order_date LIKE '%Jun';

  4. SELECT avg(price) FROM items_ordered WHERE order_date LIKE 'Jun';

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

This is the correct query for the desired output.

Keep practicing — related questions