MySQL

Q.1) (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: customer name customer address line1 customer address line2 customer phone Hardy, Thomas 83 d'Urberville Ln Jablonski, Karl Latimer, Yoshi Lebihan, Laurence 717 E Michigan Ave Lincoln, Elizabeth 4562 Rt 78 Moos, Hanna 1778 N Bovine Ave Moreno, Antonio Nagy, Helvetius 722 DaVinci Blvd. Nixon, Liz Pavarotti, Jose 187 Suffolk Ln Phillips, Rene Snyder, Howard 2732 Baker Blvd. Steel, John Summer, Martin1877 Ete Ct Casterbridge, GA 31209 | Ph #: (478) 555-1139 | Ph #: (206) 555-4112 Ph #: (503) 555-6874 Ph #: (312) 555-9441 Vancouver, WA 98684 Ph #: (360) 555-2680 Ph #: (309) 555-8755 Ph #: (253) 555-8332 Concord, MA 01742 Ph # (35 1 ) 555-1219 | Providence, RI 02909 Ph #: (401) 555-3612 Ph #: (208) 555-8097 Anchorage, AK 99508 | Ph #: (907) 555-7584 | Ph #: (503) 555-7555 | Walla Walla, WA 99362| Ph : (509) 555-7969 | Ph #: (337) 555-9441 1 305-14th Ave. S. Suite 3B | Seattle, WA 98128 City Center Plaza 516Main St. Elgin, OR 97827 Chicago, IL 60611 Peoria, IL 61638 Puyallup, WA 98373 6925 N Parkland Ave 89 Jefferson Way Suite 2 2743 Bering St Boise, ID 83720 Eugene, OR 97403 | Frogtown, LA 70563 | 12 Orchestra Terrace 14 result rows returned omm Tables customers Columns customer id customerfirstname customer_last_name customer_address customer-city customer state customer zip customer_phone customerfax - - - Indexes PRIMARY Foreign Keys Triggers items . Columns itemid title - . Columns item_id title artist unit price Indexes PRIMARY title artist uno Foreign Keys Triggers order_details . Columns order_id item_id order-qty Indexes PRIMARY order-details-fk-items Foreign Keys order_details_fk_items order details fk ordes order_details_fk_orders Triggers Orders . Columns order_id customer id orderdate shipped date - indexes PRIMARY orders fk customers Foreign Keys orders_fk_customers Triggers Views Stored Procedures FunctiOns sakila sys world