Answered step by step
Verified Expert Solution
Question
1 Approved Answer
%%%%%%MYSQL%%%%%%% I left it on the drive since I cant upload it here https://drive.google.com/file/d/1mmPLA_RNSi45-nUEGKsivluv7VzoNp0y/view?usp=sharing Q1) (25 result set below, matching all data and format aspects,
%%%%%%MYSQL%%%%%%%
I left it on the drive since I cant upload it here
https://drive.google.com/file/d/1mmPLA_RNSi45-nUEGKsivluv7VzoNp0y/view?usp=sharing
Q1) (25 result set below, matching all data and format aspects, including column headers: points) Use the om database for this question. Write a query that replicates the Customer Name Blanca, Korah Eulalia, Kelsey Holbrooke, Rashad Customer Contact Number Customer Fax Number Contact #: 6145554435 Contact #: 2095557500 Contact #: 5595558625 Contact #: 8005551957 Contact #: 8055550584 Contact#: 6145558600 Contact #: 2095551205 Fax #: 6145553928 Fax #: 2095551302 Fax #: 5595558495 Fax #: 8005552826 Fax #: 055556689 Faxa: 6145557580 Fax #: 2095552262 Customer Address 1555 w Lane Ave, Columbus, OH 43221 7833 N Ridge Rd, Sacramento, CA 95887 3467 Shaw Ave #103, Fresno, CA 93711 3250 Spring Grove Ave, Cincinnati, OH 45225 28210 N Avenue Stanford, Valencia, CA 91355 2677 Industrial Crde Dr, Columbus, OH 43260 11ERancho Madera Rd, Madison, WI 53707 Kaitlin Nickalus, Kurt Quntin, Marvin Randall, Yash 7 result rows returned Q.2) (25 points) Use the om database for this question. Write a query that replicates the result set below, matching all data and format aspects, including column headers: order_id 827 829 824 802 800 796 778 773 703 693 687 658 651 630 631 customer_name order date shipped date Justin Javen Karina Lacy Korah Blanca Yash Randall Kyle Marissa Samuel Jacobsen 2014-07-19 2014-07-26 Thalia Neftaly 2014-07-12 2014-07-21 Kirsten Story Kyle Marissa Karina Lacy Samuel Jacobsen 2014-06-05 2014-06-08 Anders Rohansen 2014-05-23 2014-06-02 Anders Rohansen 2014-05-19 2014-06-02 Erick Kaleigh Marvin Quintin 2014-05-09 2014-05-11 2014-08-02 Not Yet Shipped 2014-08-02 Not Yet Shipped 2014-08-01 Not Yet Shipped 2014-07-21 2014-07-31 2014-07-21 2014-07-28 2014-07-11 2014-07-13 2014-06-12 2014-06-19 2014-06-07 2014-06-19 2014-05-08 2014-05-18 47 result rows returned; (only a subset of the result set shown in the image above)
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