Answered step by step
Verified Expert Solution
Link Copied!

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:image text in transcribedList 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Seven Databases In Seven Weeks A Guide To Modern Databases And The NoSQL Movement

Authors: Luc Perkins, Eric Redmond, Jim Wilson

2nd Edition

1680502530, 978-1680502534

More Books

Students also viewed these Databases questions