You are tasked with the job of displaying title, artist and order_qty for items ordered. Formulate a query (include comments) to accomplish this task using table aliases and sorting by title. Here is an example of the output: Result Grid title Burt Ruggles: An Intimate Portrait Burt Ruggles: An Intimate Portrait Burt Ruggles: An Intimate Portrait Burt Ruggles: An Intimate Portrait Burt Ruggles: An Intimate Portrait Etcetera Etcetera Etcetera Etcetera Etcetera Etcetera Etcetera Etcetera Filter Rows: More Songs About Structures an... More Songs About Structures an... More Songs About Structures an... More Songs About Structures an... More Songs About Structures an... More Songs About Structures an... More Songs About Structures an... More Songs About Structures an... No Fixed Address artist Burt Ruggles Burt Ruggles Burt Ruggles Burt Ruggles Burt Ruggles Onn & Onn Onn & Onn Onn & Onn Onn & Onn Onn & Onn Onn & Onn Onn & Onn Export: order_qty 1 1 1 1 1 1 1 1 1 1 1 1 Onn & Onn 1 No Rest For... 1 No Rest For... 1 No Rest For... 1 No Rest For... 1 No Rest For... 1 No Rest For... 1 No Rest For... 1 No Rest For... 1 Sewed the ... 1 Take a screenshot that includes your query (be sure to include comments) code, sample output, and action output window. Add this to your document to submit.
Next, we're going to add another table to the statement. Edit your query from the previous step to include customer_id (this requires adding the orders table.) sort by customer_id and then title. Here is an example of the output: Filter Rows: Result Grid customer_id 1 1 1 1 2 NNNNNMM & in 67 2 2 2 2 3 3 4 5 8 8 9 9 9 title More Songs About Structures and Comestibles No Rest For The Weary On The Road With Burt Ruggles Rude Noises Umami In Concert Etcetera No Rest For The Weary Race Car Sounds Rude Noises Zone Out With Umami Umami In Concert Export: Zone Out With Umami Race Car Sounds Umami In Concert Burt Ruggles: An Intimate Portrait Umami In Concert Etcetera No Rest For The Weary Burt Ruggles: An Intimate Portrait Etcetera More Songs About Structures and Comestibles No Fixed Address Wrap Cell Content: A artist No Rest For The Weary No Rest For The Weary Burt Ruggles Jess & Odie Umami order_qty 1 1 1 2 2 Onn & Onn 1 No Rest For The Weary 1 The Ubernerds 1 Jess & Odie Umami Umami Umami The Ubernerds Umami Burt Ruggles Umami Onn & Onn No Rest For The Weary 1 1 1 1 Burt Ruggles Onn & Onn No Rest For The Weary Sewed the Vest Pocket 1 1 1 1 1 1 1 1 1 Take a screenshot that includes your query (be sure to include comments) code, sample output, and action output window. Add this to your document to submit.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!