Create a query that joins the customers and orders tables, with the customer's age being less than 25 and the order_id ranging between 2 and 4.
Answer options
A
select o.order_id,item,country from orders o join customers c where o.order_id between 2 and 4 and age <25;
B
select o.order_id,item,country from orders o join customers c on o.customer_id=c.customer_id where o.order_id between 2 and 4 and age <25;
C
select o.order_id,item,country from orders o,customers c where o.order_id in 2,4 and age <25;
Correct answer: select o.order_id,item,country from orders o join customers c on o.customer_id=c.customer_id where o.order_id between 2 and 4 and age <25;
Explanation
Quick AnswerThe correct answer is select o.order_id,item,country from orders o join customers c on o.customer_id=c.customer_id where o.order_id between 2 and 4 and age <25; because it directly addresses the core logic of Practice Set 1.
The correct query joins orders and customers using customer_id, then filters order_id between 2 and 4 and age less than 25.