Write the query to match the primary Title in title_basics instead of hard-coding a tons value.

 

GO PRINT 'CIS 275, Lab Week 4, Question 2 [3pts possible]: M*A*S*H For each season of M*A*S*H, show the total number of episodes and total number of votes. Display results ordered by season. Write your query to match the primaryTitle in title_basics instead of hard-coding a tconst value. Hint: title_episode.parentTconst is the series, title_episode.tconst is the episode. Episodes have ratings in title_ratings, where the number of votes for the episode is also contained. Correct results will look like this: Season Number Number of Episodes Total Votes by Season 1 IN34 2 5 6 7 8 9 10 11 +CHAR(10) NNNNNNNNN 15 24 24 24 24 24 24 25 25 20 21 16 8470 6724 6383 5859 5546 5092 5362 5340 4177 4049 5849