Use the om database for this question. Write a query that replicates the result set below,...

  

Transcribed Image Text:

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 Justin Javen Karina Lacy Korah Blanca Yash Randall Kyle Marissa Samuel Jacobsen Thalia Neftaly Kirsten Story Kyle Marissa Karina Lacy Samuel Jacobsen Anders Rohansen Anders Rohansen Erick Kaleigh Marvin Quintin order_date 2014-08-02 2014-08-02 2014-08-01 2014-07-21 shipped_date Not Yet Shipped Not Yet Shipped Not Yet Shipped 2014-07-31 2014-07-21 2014-07-28 2014-07-19 2014-07-26 2014-07-12 2014-07-21 2014-07-11 2014-07-13 2014-06-12 2014-06-19 2014-06-07 2014-06-19 2014-06-05 2014-06-08 2014-05-23 2014-06-02 2014-05-19 2014-06-02 2014-05-08 2014-05-18 2014-05-09 2014-05-11 47 result rows returned; (only a subset of the result set shown in the image above) 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: vendor_state terms_description Net due 20 days Net due 30 days Net due 30 days Net due 30 days Net due 30 days Net due 30 days Net due 30 days Net due 30 days NY Net due 60 days NJ Net due 60 days NV 10 result rows returned NJ NC NJ NJ NV NY NY vendor_name Simon Direct Inc Baker & Taylor Books Rich Advertising RR Bowker United Parcel Service The Mailers Guide Co Venture Communications Int'l American Booksellers Assoc Newbrige Book Clubs Cahners Publishing Company vendor_id 76 47 27 32 122 60 38 61 5 100 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 Justin Javen Karina Lacy Korah Blanca Yash Randall Kyle Marissa Samuel Jacobsen Thalia Neftaly Kirsten Story Kyle Marissa Karina Lacy Samuel Jacobsen Anders Rohansen Anders Rohansen Erick Kaleigh Marvin Quintin order_date 2014-08-02 2014-08-02 2014-08-01 2014-07-21 shipped_date Not Yet Shipped Not Yet Shipped Not Yet Shipped 2014-07-31 2014-07-21 2014-07-28 2014-07-19 2014-07-26 2014-07-12 2014-07-21 2014-07-11 2014-07-13 2014-06-12 2014-06-19 2014-06-07 2014-06-19 2014-06-05 2014-06-08 2014-05-23 2014-06-02 2014-05-19 2014-06-02 2014-05-08 2014-05-18 2014-05-09 2014-05-11 47 result rows returned; (only a subset of the result set shown in the image above) 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: vendor_state terms_description Net due 20 days Net due 30 days Net due 30 days Net due 30 days Net due 30 days Net due 30 days Net due 30 days Net due 30 days NY Net due 60 days NJ Net due 60 days NV 10 result rows returned NJ NC NJ NJ NV NY NY vendor_name Simon Direct Inc Baker & Taylor Books Rich Advertising RR Bowker United Parcel Service The Mailers Guide Co Venture Communications Int'l American Booksellers Assoc Newbrige Book Clubs Cahners Publishing Company vendor_id 76 47 27 32 122 60 38 61 5 100