Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Order PID Description Quantity 300 140 230 Price Vendor OID Date CID Shampoo Soap Detergent 4 Unique traders AT Cosmetics General traders 1 50 1 2012/5/23 1 40 30 2012/5/24 2 2016/4/23 3. 2016/2/12 6. 2016/1/10 4 Milk Lemon Max Unique traders General traders Foodie Shop 14 33 4 10 20 Chocolate 34 34 Invoice Customer OrderNo ProductID Quantity 2. CustomerID Name city 1 2 1 Ali Rawalpindi 3 4 1 Ahmad Islamabad 1 Umer Chakwal 2. 2 6 3 Karim Islamabad 2 1 Shafiq Islamabad 5 3 2 6. Waleed Rawat 4 Afzal Islamabad 4 4 2 1 Bilal Rawalpindi 4 4 Write SQL queries for the following statements (Use only Cartesian product and join) 1. Show name of customer and orderno who have placed any order and belong to "Islamabad". 2. Show name of customer and product description who placed order before 2016/2/23. 3. Show data of those customer who place two or more than two order in same day.

Order PID Description Quantity 300 140 230 Price Vendor OID Date CID Shampoo Soap Detergent 4 Unique traders AT Cosmetics General traders 1 50 1 2012/5/23 1 40 30 2012/5/24 2 2016/4/23 3. 2016/2/12 6. 2016/1/10 4 Milk Lemon Max Unique traders General traders Foodie Shop 14 33 4 10 20 Chocolate 34 34 Invoice Customer OrderNo ProductID Quantity 2. CustomerID Name city 1 2 1 Ali Rawalpindi 3 4 1 Ahmad Islamabad 1 Umer Chakwal 2. 2 6 3 Karim Islamabad 2 1 Shafiq Islamabad 5 3 2 6. Waleed Rawat 4 Afzal Islamabad 4 4 2 1 Bilal Rawalpindi 4 4 Write SQL queries for the following statements (Use only Cartesian product and join) 1. Show name of customer and orderno who have placed any order and belong to "Islamabad". 2. Show name of customer and product description who placed order before 2016/2/23. 3. Show data of those customer who place two or more than two order in same day.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
Product Order PID Description Quantity 300 Price Vendor OID Date 2012/5/23 2 CID Unique traders AT Cosmetics General traders Unique traders General traders Foodie Shop Shampoo 50 1 1 2 Soap 140 230 40 30 2012/5/24 3 Detergent 4 2016/4/23 4 Milk 14 33 3 2016/2/12 2016/1/10 4 Lemon Max 10 20 6 1 6. Chocolate 34 34 Invoice Customer OrderNo 1 ProductID Quantity CustomerID Name city 1 1 Ali Rawalpindi 1 3 1 Ahmad Islamabad 4 2 1 Umer Chakwal 2 6. 3 Каrim Islamabad 2 3 1 Shafig Islamabad 3 2 6. Waleed Rawat 4 Afzal Islamabad 4 3 4 1 Bilal Rawalpindi 4 4 Write SQL queries for the following statements (Use only Cartesian product and join) 1. Showname of customerand orderno who have placed any order and belong to "Islamabad". 2. Showname of customer and product description who placed order before 2016/2/23. 3. Show data of those customer who place two or more than two order in same day. 4. Showdata of those product that are purchased by those customer who neither belong 5. To"Rawat"nor "Rawalpindi" nor "Chakwal". 6. Show cname of those customer who order a product with low price. 7. Show description, vendor and order date that are order by after 2016/2/23 and order placed by other Than "Bilal". 8. Show data of products who have ordered by more than 3 time. 9. Showdetail of those products which not purchased by any customer. 10. Showlist of customer name and product vendor they have ordered recently. ww 11. Show Customer city and invoice quantity of those product whose quantity is minimum.
Transcribed Image Text:Product Order PID Description Quantity 300 Price Vendor OID Date 2012/5/23 2 CID Unique traders AT Cosmetics General traders Unique traders General traders Foodie Shop Shampoo 50 1 1 2 Soap 140 230 40 30 2012/5/24 3 Detergent 4 2016/4/23 4 Milk 14 33 3 2016/2/12 2016/1/10 4 Lemon Max 10 20 6 1 6. Chocolate 34 34 Invoice Customer OrderNo 1 ProductID Quantity CustomerID Name city 1 1 Ali Rawalpindi 1 3 1 Ahmad Islamabad 4 2 1 Umer Chakwal 2 6. 3 Каrim Islamabad 2 3 1 Shafig Islamabad 3 2 6. Waleed Rawat 4 Afzal Islamabad 4 3 4 1 Bilal Rawalpindi 4 4 Write SQL queries for the following statements (Use only Cartesian product and join) 1. Showname of customerand orderno who have placed any order and belong to "Islamabad". 2. Showname of customer and product description who placed order before 2016/2/23. 3. Show data of those customer who place two or more than two order in same day. 4. Showdata of those product that are purchased by those customer who neither belong 5. To"Rawat"nor "Rawalpindi" nor "Chakwal". 6. Show cname of those customer who order a product with low price. 7. Show description, vendor and order date that are order by after 2016/2/23 and order placed by other Than "Bilal". 8. Show data of products who have ordered by more than 3 time. 9. Showdetail of those products which not purchased by any customer. 10. Showlist of customer name and product vendor they have ordered recently. ww 11. Show Customer city and invoice quantity of those product whose quantity is minimum.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS