joaoftrodrigues / atpdb-cleanup-and-conversion-to-relational

0 stars 0 forks source link

SQL Queries - Task Center #14

Open joaoftrodrigues opened 1 year ago

joaoftrodrigues commented 1 year ago

Description

Organize tasks for SQL queries that must be done on data. Must be studied the possibility of using indexes to optimize data access.

Queries

[ ] Number of players, tournaments and rounds per country
[ ] Top 10 players (Name + win rate) ordered by win rate
[ ] Top 10 left-handed players (Name + winrate) in Grand Slam games
[ ] Top 5 players (Name + number of winning games in Hard Ground)