Question: Q2.) (25 points) Use the om database for this question. Write a query that replicates the result set below, matching all data and format aspects,

Q2.) (25 points) Use the om database for this question. Write

Q2.) (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. For this question, you must use a UNION. Points will be deducted for using IFNULL, COALESCE, etc. DC order_date shipped_date customer_state customer_address customer_full_name 2014-08-02 Not yet shipped NY 828 S Broadway Justin Javen 2014-08-02 Not yet shipped CA 882 W Easton Wy Karina Lacy 2014-08-01 Not yet shipped OH 1555 W Lane Ave Korah Blanca 2014-07-21 2014-07-31 WI 11 E Rancho Madera Rd Yash Randall 2014-07-21 2014-07-28 AZ 789 E Mercy Ave Kyle Marissa 2014-07-19 2014-07-26 CA 3433 E Widget Ave Samuel Jacobsen 2014-07-12 2014-07-21 CA 2508 W Shaw Ave Thalia Neftaly 2014-07-11 2014-07-13 2401 Wisconsin Ave NW Kirsten Story 2014-06-12 2014-06-19 AZ 789 E Mercy Ave Kyle Marissa 2014-06-07 2014-06-19 CA 882 W Easton Wy Karina Lacy 2014-06-05 2014-06-08 CA 3433 E Widget Ave Samuel Jacobsen 2014-05-23 2014-06-02 12345 E 67th Ave NW Anders Rohansen 2014-05-19 2014-06-02 MD 12345 E 67th Ave NW Anders Rohansen 2014-05-09 2014-05-11 OH 2677 Industrial Circle Dr Marvin Quintin 2014-05-08 2014-05-18 NC Five Lakepointe Plaza, ... Erick Kaleigh 2014-05-05 2014-05-10 3433 E Widget Ave Samuel Jacobsen 2014-05-04 2014-05-09 WI 11 E Rancho Madera Rd Yash Randall 2014-04-25 2014-05-04 NC Five Lakepointe Plaza, ... Erick Kaleigh 2014-04-25 2014-05-02 3250 Spring Grove Ave Kaitlin Hostlery 2014-04-21 2014-04-27 CA 1033 N Sycamore Ave. Dakota Baylee 2014-03-23 2014-04-03 CA 3433 E Widget Ave Samuel Jacobsen ang na 2011 4 10 MAIT 11 Nancho Madars od Vash Pand- The result set should only contain 47 rows. Only a subset is shown in this preview. MD CA OH Q2.) (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. For this question, you must use a UNION. Points will be deducted for using IFNULL, COALESCE, etc. DC order_date shipped_date customer_state customer_address customer_full_name 2014-08-02 Not yet shipped NY 828 S Broadway Justin Javen 2014-08-02 Not yet shipped CA 882 W Easton Wy Karina Lacy 2014-08-01 Not yet shipped OH 1555 W Lane Ave Korah Blanca 2014-07-21 2014-07-31 WI 11 E Rancho Madera Rd Yash Randall 2014-07-21 2014-07-28 AZ 789 E Mercy Ave Kyle Marissa 2014-07-19 2014-07-26 CA 3433 E Widget Ave Samuel Jacobsen 2014-07-12 2014-07-21 CA 2508 W Shaw Ave Thalia Neftaly 2014-07-11 2014-07-13 2401 Wisconsin Ave NW Kirsten Story 2014-06-12 2014-06-19 AZ 789 E Mercy Ave Kyle Marissa 2014-06-07 2014-06-19 CA 882 W Easton Wy Karina Lacy 2014-06-05 2014-06-08 CA 3433 E Widget Ave Samuel Jacobsen 2014-05-23 2014-06-02 12345 E 67th Ave NW Anders Rohansen 2014-05-19 2014-06-02 MD 12345 E 67th Ave NW Anders Rohansen 2014-05-09 2014-05-11 OH 2677 Industrial Circle Dr Marvin Quintin 2014-05-08 2014-05-18 NC Five Lakepointe Plaza, ... Erick Kaleigh 2014-05-05 2014-05-10 3433 E Widget Ave Samuel Jacobsen 2014-05-04 2014-05-09 WI 11 E Rancho Madera Rd Yash Randall 2014-04-25 2014-05-04 NC Five Lakepointe Plaza, ... Erick Kaleigh 2014-04-25 2014-05-02 3250 Spring Grove Ave Kaitlin Hostlery 2014-04-21 2014-04-27 CA 1033 N Sycamore Ave. Dakota Baylee 2014-03-23 2014-04-03 CA 3433 E Widget Ave Samuel Jacobsen ang na 2011 4 10 MAIT 11 Nancho Madars od Vash Pand- The result set should only contain 47 rows. Only a subset is shown in this preview. MD CA OH

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I need help with these two questions on SQL. Here is the link to sql file with ap and om database: https://drive.google.com/file/d/1R70bmm1KlAXfqndPtZ2iV32VHQudYjxd/view?usp=sharing Q.1) (25 points)...

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: Q,2) (25 points) Use the om...

1,'US Postal Service', 'Attn: Supt. Window Services','PO Box 7005','Madison','WI','53707','(800) 555-1205', 'Alberto','Francesco', 1,552), (2, 'National Information Data Ctr','PO Box...

MySQL Q2.) (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. For this question,...

%%%%%%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...

MySQL Under the shipped_date tab, it's returning all 'Not yet shipped'. It's also returning 1150 rows, the returned wants 47 rows. I am very confused on how to fix this. I will provide a picture of...

MySQL Q2.) (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. For this question,...

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...

Q.2) (25 points) Use the ex database for this question. Write a query that replicates the result set below, matching all data and format aspects, including column headers: Result Grid invoice number...

Suppose, you have to develop an algorithm for optimal arrangement of 5 objects (charger fan, laptop, sandwich maker, electric kettle, cell phone) in a carton which can carry a weight of maximum 20...

Today, September 20, 2022, you received your annual salary (for 2022) payment of $85,000, which, unfortunately, you have already spent. However, beginning September 20, 2023, you plan to deposit 10%...

1. Li Ting standing at P. is flying a kite attached to a string of length 140 m. The angle of elevation of the kite K from her hand is 58, Assuming that the string is taut, determine the vertical...

Journalize the following redemption transactions: 1. Oolong Corporation retired $130,000 face value bonds on June 30, 2017, at 103. The carrying value of the bonds at the redemption date was...