Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use `bigquery-public-data.ncaa_basketball.mbb_historical_teams_seasons` dataset and write code in SQL Definition: Team X is a top performer on season Y if no other team had more wins
Use `bigquery-public-data.ncaa_basketball.mbb_historical_teams_seasons` dataset and write code in SQL
Definition: Team X is a top performer on season Y if no other team had more wins than X in the same season. This includes teams with either null or non-null . What five teams (identify them here by their "markets") were top performers in the most seasons between 1900 and 2000 (inclusive), and how many times were they top performers? Output the team markets and the number of times each team was a top performer. If there are ties in the final output, break them by giving a higher ranking to team markets that come first alphabetically. Ignore teams with NULL markets only in the final outputStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started