Answered step by step
Verified Expert Solution
Question
1 Approved Answer
17) List all orders (Order Number) over $25500 showing the company placing the order, the Customer Rep assign to the company, the Office id and
17) List all orders (Order Number) over $25500 showing the company placing the order, the Customer Rep assign to the company, the Office id and the city where the Customer Rep works in, such that the Customer Rep's manager is not the person who took the order. 18) List order_num and name of the rep who took the order and the name of his/her manager and long as the manager's office is in New York' 19) List all products (Mfr_id, ProductId, and Description), customers (CustNum, Company) who have bought that product, and orders (Order Number, and Order Date) where the order
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started