Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M. Kroenke

1st Edition

0130086509, 978-0130086501

More Books

Students also viewed these Databases questions

Question

Technology. Refer to Case

Answered: 1 week ago