Question: Inevitably, there are things that Santa's Workshop makes, but never get requested in those letters to Santa. Like socks, ornamental wooden spoons, and school supplies

 Inevitably, there are things that Santa's Workshop makes, but never getrequested in those letters to Santa. Like socks, ornamental wooden spoons, and

Inevitably, there are things that Santa's Workshop makes, but never get requested in those letters to Santa. Like socks, ornamental wooden spoons, and school supplies YUCK!. Santa needs to make performance improvements back at HQ. He his spending lots of money making items for Christmas, but there is SO much leftover at the end of the season! And, lets be honest -- who wants school supplies for Christmas? Santa's problem is, his list only shows items that kids have asked for, not what they haven't requested. How could Santa produce a list of Toys NOT on the list? We can find this using a left outer join. More info here: https://www.w3schools.com/sql/sql_join_left.asp Q1.6 What toys are NOT on Santa's list? Hint: There are three. Grouping Santa thinks he needs to reorganize his manufacturing process, and is interested in understanding the three most popular toy categories. Q1.7 What are the three most popular toy categories? Q1.8 What are the three least popular? Aggregates Assignment 3 2023.md 3/9/2023 Q1.9 Speaking of Money, how much did Christmas cost Santa this year (The total value of all toys on Santa's List)? Q1.10 What was the average cost of a toy on Santa's List

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 General Management Questions!