Games won by a single point

I love to watch buzzer beaters that won games, a last second free throw or a clutch shot that leads a team to victory. It’s a great reminder to rest in the end, not in the middle. In this exercise, let’s find out how many games in NBA were won by a single point difference.

The NBA dataset contains stats of NBA games since 1949. It is regularly updated.

The dataset contains aggregated game stats (team_game_stats table) and individual player stats per quarter or overtime period (player_period_stats).

Have a ball!

Hi, it’s Anatoli, the author of SQL Habit.

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit is also a collection of Practice exercises (you’re looking at one atm) based on various datasets (E-commerce, Finance, etc). They’re meant to deepen your SQL and Data Analysis knowledge , prepare you for any challenge at work or a job interview.