Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL: List the type and average toy sales per type. Include in the results only types that have more than one character (on the sample
SQL:List the type and average toy sales per type. Include in the results only types that have more than one character (on the sample above, only types 1 and 3 have more than 1 character). The table is called characters.
| id | name | movie | year | toys_sold | type | description | 1 | Captain Hook | Peter Pan 1953 2 | Tiger Lily Peter Pan | 1953 3 | Pocahontas | Pocahontas | 1995 4 | Meeko | Pocahontas | 1995 5 Woody | Toy Story | NULL 6 | Flik A Bug's Life | 1998 | 7 | Dot A Bug's Life | 1998 | | 8 | Sofia, the First | Forever Royal | 2018 30 2 | Human 10 | 1 | Human 20 | 1 | Human 5 | NULL | unknown 45 | 4 Toy 5| 3 | Animal 5| 3 | Animal 50 | 1 | HumanStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started