Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How to solve these ten questions ??? 218 IU 4G:all 80% 18:54 PM Microsoft Word-Lab 9.docx Lab 9: SQL DML Query in MySQL SQL Query

How to solve these ten questions

image text in transcribed

image text in transcribedimage text in transcribed

image text in transcribed???

218 IU 4G:all 80% 18:54 PM Microsoft Word-Lab 9.docx Lab 9: SQL DML Query in MySQL SQL Query from Multiple Tables IS 4420, Database Fundamentals We import the four tables using the same customer order.sql script. Open a lab9.tt text file to hold your working SQL statements. Once you have ensured that a particular SQL statement below is working, paste it into this text file. DML: query 1. Do a Cartesian Product from all four tables (Customer, Product, Orders, Orderline). 2 (20400 rows) List customer information for customers that have placed orders after 2008-10-27 (Use Equi Join). 2. cust idcust name streetcity state zip order id order date cust id 12 Jennifer English 250 State Tucson AZ 45112 1008 2008-10-30 1009 2008-11-01 12 200 South SLC UT 84102 4 Mary Lee 1 John Doe 200 Maplo SLCUT 84102 1010 2008-11-05 (3 rows) 218 IU 4G:all 80% 18:54 PM Microsoft Word-Lab 9.docx Lab 9: SQL DML Query in MySQL SQL Query from Multiple Tables IS 4420, Database Fundamentals We import the four tables using the same customer order.sql script. Open a lab9.tt text file to hold your working SQL statements. Once you have ensured that a particular SQL statement below is working, paste it into this text file. DML: query 1. Do a Cartesian Product from all four tables (Customer, Product, Orders, Orderline). 2 (20400 rows) List customer information for customers that have placed orders after 2008-10-27 (Use Equi Join). 2. cust idcust name streetcity state zip order id order date cust id 12 Jennifer English 250 State Tucson AZ 45112 1008 2008-10-30 1009 2008-11-01 12 200 South SLC UT 84102 4 Mary Lee 1 John Doe 200 Maplo SLCUT 84102 1010 2008-11-05 (3 rows)

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

Databases On The Web Designing And Programming For Network Access

Authors: Patricia Ju

1st Edition

1558515100, 978-1558515109

More Books

Students also viewed these Databases questions

Question

=+1 Where are the best places in the world to live (and work)?

Answered: 1 week ago

Question

=+Are you interested in working on global teams?

Answered: 1 week ago

Question

=+Do you want to work from home?

Answered: 1 week ago