Question: Write a SQL statement to find all orders where at least 100 items BR01, BRO2, or BRO3 were ordered. You'll want to return order number,

Write a SQL statement to find all orders where at

Write a SQL statement to find all orders where at

Write a SQL statement to find all orders where at least 100 items BR01, BRO2, or BRO3 were ordered. You'll want to return order number, product ID, and quantity for the OrderItems table, filtering by both the product ID and quantity. HINT: Depending on how you write your filter, you may need to pay attention to the order of evaluation. (score: 25%) 00 Orders order_num order_date cust_id 18 Customers cust_id cust_name cust_address cust_city cust_state cust_zip cust_country cust_contact cust email Orderitems Vorder_num order_item prod_id quantity item_price 18 Vendors 8 vend_id vend name vend address vend city vend_state vend zip vend country Products Y prod_id vend_id prod_name prod_price prod_desc

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!