Answered step by step
Verified Expert Solution
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
???
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
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