Question: 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:SQL:List the type and average toy sales per type. Include in theList 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 | Human

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 Databases Questions!