Using the netflix_history table, count how many episodes you watched for these two shows:
For this exercise, consider the show name to be the initial part of title before :. If a title does not contain :, use the full title.
Show the columns show_name and total_episodes, and sort by show_name.
Hints
-
Hint 1
First build a derived table with show_name.
If title contains :, keep only the part before the colon.
-
Hint 2
Inside the subquery, group by show_name.
Also calculate COUNT(*) as the total watched episodes.
-
Hint 3
In the outer query, keep only Arcane and Squid Game.
Order the result by show_name.