Question: Final Exam 3. For the following Relational Model, write the following SQL queries: Dider Order ID Vendor Code Date Description Created By Name: Order

Final Exam 3. For the following Relational Model, write the following SQL queries: Dider Order ID Vendor Code Date Description Created By Name: Order Linellem Product Code Order ID Amount Unit Price Description Product Product Code Vender Code Venders Price Selling Price Quantity_On_Hand Order Quantity 3.a) Return all orders, with the following fields: Order_ID, Date, and Description, that occurred on or before 5/11/98. (15 points) 3.b). Return all orders, with the following fields: Order_ID, Date, and Description, that have a product that has a selling price of exactly $40. (20 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
