You can catch the replay here:
FOR ROCKSET SWAG DOLLARS
How can we improve this query based on the concepts @david gave during his Office Hours?Can we use the Query Profiler to see if we should change the JOIN? or apply a HINT? Reply to this thread to get the SWAG
SELECT
SUM(m.revenue) as total_revenue,
SUM(m.runtime) as total_runtime,
SUM(m.vote_count)/COUNT(*) as avg_vote_count,
SUM(m.popularity) / COUNT(*) as avg_popularity,
SUM(r.rating)/ COUNT(*) as avg_rating
FROM
commons.movies m
JOIN commons.movie_ratings r ON m.id = r.movieId
WHERE m.release_date LIKE β2006%β
GROUP BY m.original_language
Resources