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

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

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Solution By applying the loop current method to tackle the problem of locating the loop currents in ... View the full answer