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 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 2014-08-02 2014-08-01 2014-07-21 2014-07-21 Not Yet Shipped Not Yet Shipped Not Yet Shipped 2014-07-31 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) Q.4) (25 points) Use the ap database for this question. Write a query that replicates the result set below, matching all data and format aspects, including column headers: terms_description vendor_state vendor_name vendor id 76 47 27 32 122 60 Net due 20 days NJ Net due 30 days NC Net due 30 days NJ Net due 30 days N3 Net due 30 days NV Net due 30 days NY Net due 30 days NY Net due 30 days NY Net due 60 days NJ Net due 60 days NV Simon Direct Inc Baker &Taylor Books Rich Advertising RR Bowker United Parcel Service The Mailers Guide Co Venture Communications Int 38 American Booksellers Assoc 61 Newbrige Book Clubs Cahners Publishing Company 100 10 result rows returned