I’ve this database schema on a Oracle 12c database :
I am making an attempt to reply this query :
What’s the recreation through which Dallas Mavericks had the largest share of profitable 3-point pictures ?
I’ve managed to reply this query with this question:
SELECT HOME_TEAMS.TEAM_NAME "HOME TEAM",
AWAY_TEAMS.TEAM_NAME "AWAY TEAM",
GAMES.GAME_DATE "DATE",
TEAMS.TEAM_ID "GENERIC ID",
HOME_TEAMS.TEAM_ID "HOME_ID",
AWAY_TEAMS.TEAM_ID "AWAY_ID",
GAME_STATISTICS.X3POINTSHOTS_PERCENTAGE "Three POINTS PERCENTAGE"
FROM GAMES_TEAMS_STATISTICS
INNER JOIN GAMES ON GAMES_TEAMS_STATISTICS.GAME_ID = GAMES.GAME_ID
INNER JOIN TEAMS ON GAMES_TEAMS_STATISTICS.TEAM_ID = TEAMS.TEAM_ID
INNER JOIN TEAMS HOME_TEAMS ON GAMES.HOME_TEAM = HOME_TEAMS.TEAM_ID
INNER JOIN TEAMS AWAY_TEAMS ON GAMES.AWAY_TEAM = AWAY_TEAMS.TEAM_ID
INNER JOIN GAME_STATISTICS ON GAMES_TEAMS_STATISTICS.STATS_ID = GAME_STATISTICS.STATS_ID
WHERE TEAMS.TEAM_ACRONYM = 'DAL'
ORDER BY GAME_STATISTICS.X3POINTSHOTS_PERCENTAGE DESC
FETCH FIRST 1 ROWS WITH TIES;
Nonetheless, to reply this query , I be part of the groups desk Three occasions. Is there any means I can write this question in a extra environment friendly means , avoiding so many joins ?