Movie/TV Show Ratio
ASKED IN INTERVIEWNetflix
Problem Statement
Analyze the Netflix catalog to find the ratio of Movies to TV Shows.
Rules:
- Output columns: type, percentage.
- percentage = (total of type / total titles) * 100.
- Round results to 2 decimal places.
- Results must be sorted by percentage in descending order.
Tests your understanding of
Common Table Expressions, Aggregation and Mathematical Functions
Input Tables
netflix_titles
| show_id(VARCHAR) | type(VARCHAR) | title(VARCHAR) |
|---|---|---|
| s1 | Movie | The Irishman |
| s2 | TV Show | Stranger Things |
| s3 | Movie | Extraction |
| s4 | Movie | Roma |
| s5 | TV Show | The Crown |
| s6 | TV Show | Ozark |
| s7 | Movie | Bird Box |
| s8 | Movie | Don’t Look Up |
Expected Output
| type(VARCHAR) | percentage(DECIMAL) |
|---|---|
| Movie | 62.5 |
| TV Show | 37.5 |
Tags
MediumASKED IN INTERVIEWCommon Table ExpressionsAggregationMathematical Functions
15-20 min
48%