Answered step by step
Verified Expert Solution
Question
1 Approved Answer
use the tables of the Order Entry database introduced in the Problems section of Chapter 4. When for- h roblems, remember that the EmpVo foreign
use the tables of the Order Entry database introduced in the Problems section of Chapter 4. When for- h roblems, remember that the EmpVo foreign key in the OrderTb table allows null values. An order does rulating x ave an associated employee if taken over the Internet. L Usnga Type I nested query, list the customer number, name (first and last), and city of each customer who has a bulance greater than $150 and placed an order in February 2013. 2. Using a Type Il nested query, list the customer number, name (first and last), and city of each custom a balance greater than $150 and placed an order in February 2013. Using two Type I nested queries, list the product number, the name, and the price of products with a than $150 that were ordered on January 23, 2013. 3. 4. Using two Type I nested queries and another join style, list the product number, name, and price of bhy cust a price greater than S150 that were ordered in January 2013 by customers with balances greater List the order number, order date, employce number, and employee name (first and last) of orders ary 23, 2013. List the order even if there is not an associated employee. aofordrpaced on lea 5. placed Product OrdLine Customer ProdNo CustNo CustFirstName CustLastName CustStreet CustCity CustState CustZip CustBal OrdNo ProdNo Qty ProdName ProdMfg ProdQOH ProdPrice ProdNextShipDate OrderTbl OrdNo OrdDate CustNo EmpNo OrdName OrdStreet OrdCity OrdState OrdZip Employee Employee 1 EmpNo EmpNo EmpFirstName EmpLastName EmpPhone SupEmpNo EmpCommRate EmpEmail EmpFirstName EmpLastName EmpPhone SupEmpNo EmpCommRate EmpEmail
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