Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 output

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Visualization A Practical Introduction

Authors: Kieran Healy

1st Edition

0691181624, 978-0691181622

More Books

Students also viewed these Databases questions