Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

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

JDBC Database Programming With J2ee

Authors: Art Taylor

1st Edition

0130453234, 978-0130453235

More Books

Students also viewed these Databases questions

Question

What lessons in OD contracting does this case represent?

Answered: 1 week ago

Question

Does the code suggest how long data is kept and who has access?

Answered: 1 week ago