runtimetask RANK / DENSE_RANK · medium
Second-highest home-run total per team
For the 2025 regular season, return team_id, player_id and home_runs for players at the second-highest distinct home-run total on their team (all ties).
what to return
- Columns
team_idplayer_idhome_runsin this order- Rows
- 32 rows · any order
- Skill
- Find the second distinct value within each group. Refresher: RANK & DENSE_RANK →
expected result
Your query should return exactly these columns and values. Run it and compare.
expected result32 rows · any order
| team_id | player_id | home_runs |
|---|---|---|
| ANA | wardt002 | 36 |
| ARI | carrc005 | 31 |
| ATH | langs001 | 31 |
first 3 of 32 rows
data you can query
Sports dataset: the first 6 rows of each table. Under each column name: the kind of value it holds, and which table it links to. Your queries run on all rows.
player_game_stats17 columns · 73,029 rows
| game_idtext · links to games | player_idtext · links to players | team_idtext · links to teams | batting_ordernumber | startednumber | plate_appearancesnumber | at_batsnumber | runsnumber | hitsnumber | doublesnumber | triplesnumber | home_runsnumber | rbinumber | walksnumber | strikeoutsnumber | stolen_basesnumber | hit_by_pitchnumber |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CHN202503180 | ohtas001 | LAN | 1 | 1 | 5 | 5 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| CHN202503180 | edmat001 | LAN | 2 | 1 | 5 | 5 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
| CHN202503180 | hernt002 | LAN | 3 | 1 | 5 | 4 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 |
| CHN202503180 | smitw003 | LAN | 4 | 1 | 5 | 2 | 0 | 1 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 0 |
| CHN202503180 | muncm001 | LAN | 5 | 1 | 5 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 |
| CHN202503180 | herne001 | LAN | 6 | 1 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
- game_idtext · links to games
- CHN202503180
- player_idtext · links to players
- ohtas001
- team_idtext · links to teams
- LAN
- batting_ordernumber
- 1
- startednumber
- 1
- plate_appearancesnumber
- 5
- at_batsnumber
- 5
- runsnumber
- 2
- hitsnumber
- 2
- doublesnumber
- 1
- triplesnumber
- 0
- home_runsnumber
- 0
- rbinumber
- 0
- walksnumber
- 0
- strikeoutsnumber
- 1
- stolen_basesnumber
- 0
- hit_by_pitchnumber
- 0
- game_idtext · links to games
- CHN202503180
- player_idtext · links to players
- edmat001
- team_idtext · links to teams
- LAN
- batting_ordernumber
- 2
- startednumber
- 1
- plate_appearancesnumber
- 5
- at_batsnumber
- 5
- runsnumber
- 0
- hitsnumber
- 1
- doublesnumber
- 0
- triplesnumber
- 0
- home_runsnumber
- 0
- rbinumber
- 1
- walksnumber
- 0
- strikeoutsnumber
- 0
- stolen_basesnumber
- 0
- hit_by_pitchnumber
- 0
- game_idtext · links to games
- CHN202503180
- player_idtext · links to players
- hernt002
- team_idtext · links to teams
- LAN
- batting_ordernumber
- 3
- startednumber
- 1
- plate_appearancesnumber
- 5
- at_batsnumber
- 4
- runsnumber
- 1
- hitsnumber
- 1
- doublesnumber
- 0
- triplesnumber
- 0
- home_runsnumber
- 0
- rbinumber
- 1
- walksnumber
- 1
- strikeoutsnumber
- 1
- stolen_basesnumber
- 0
- hit_by_pitchnumber
- 0
- game_idtext · links to games
- CHN202503180
- player_idtext · links to players
- smitw003
- team_idtext · links to teams
- LAN
- batting_ordernumber
- 4
- startednumber
- 1
- plate_appearancesnumber
- 5
- at_batsnumber
- 2
- runsnumber
- 0
- hitsnumber
- 1
- doublesnumber
- 0
- triplesnumber
- 0
- home_runsnumber
- 0
- rbinumber
- 1
- walksnumber
- 3
- strikeoutsnumber
- 0
- stolen_basesnumber
- 0
- hit_by_pitchnumber
- 0
- game_idtext · links to games
- CHN202503180
- player_idtext · links to players
- muncm001
- team_idtext · links to teams
- LAN
- batting_ordernumber
- 5
- startednumber
- 1
- plate_appearancesnumber
- 5
- at_batsnumber
- 3
- runsnumber
- 0
- hitsnumber
- 0
- doublesnumber
- 0
- triplesnumber
- 0
- home_runsnumber
- 0
- rbinumber
- 0
- walksnumber
- 2
- strikeoutsnumber
- 2
- stolen_basesnumber
- 0
- hit_by_pitchnumber
- 0
- game_idtext · links to games
- CHN202503180
- player_idtext · links to players
- herne001
- team_idtext · links to teams
- LAN
- batting_ordernumber
- 6
- startednumber
- 1
- plate_appearancesnumber
- 5
- at_batsnumber
- 5
- runsnumber
- 0
- hitsnumber
- 0
- doublesnumber
- 0
- triplesnumber
- 0
- home_runsnumber
- 0
- rbinumber
- 0
- walksnumber
- 0
- strikeoutsnumber
- 1
- stolen_basesnumber
- 0
- hit_by_pitchnumber
- 0
first 6 of 73,029 rows · your queries use all of them
games13 columns · 23,168 rows
| game_idtext · unique id | seasonnumber · links to seasons | game_datedate | game_numbernumber | game_typetext | venue_idtext · links to venues | home_team_idtext · links to teams | away_team_idtext · links to teams | home_scorenumber | away_scorenumber | day_nighttext | attendancenumber | duration_minutesnumber |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ANA201604040 | 2016 | 2016-04-04 | 0 | regular | ANA01 | ANA | CHN | 0 | 9 | night | 44020 | 188 |
| ANA201604050 | 2016 | 2016-04-05 | 0 | regular | ANA01 | ANA | CHN | 1 | 6 | night | 37042 | 154 |
| ANA201604070 | 2016 | 2016-04-07 | 0 | regular | ANA01 | ANA | TEX | 4 | 3 | night | 39089 | 191 |
| ANA201604080 | 2016 | 2016-04-08 | 0 | regular | ANA01 | ANA | TEX | 3 | 7 | night | 35207 | 210 |
| ANA201604090 | 2016 | 2016-04-09 | 0 | regular | ANA01 | ANA | TEX | 1 | 4 | night | 38106 | 173 |
| ANA201604100 | 2016 | 2016-04-10 | 0 | regular | ANA01 | ANA | TEX | 3 | 1 | day | 35097 | 163 |
- game_idtext · unique id
- ANA201604040
- seasonnumber · links to seasons
- 2016
- game_datedate
- 2016-04-04
- game_numbernumber
- 0
- game_typetext
- regular
- venue_idtext · links to venues
- ANA01
- home_team_idtext · links to teams
- ANA
- away_team_idtext · links to teams
- CHN
- home_scorenumber
- 0
- away_scorenumber
- 9
- day_nighttext
- night
- attendancenumber
- 44020
- duration_minutesnumber
- 188
- game_idtext · unique id
- ANA201604050
- seasonnumber · links to seasons
- 2016
- game_datedate
- 2016-04-05
- game_numbernumber
- 0
- game_typetext
- regular
- venue_idtext · links to venues
- ANA01
- home_team_idtext · links to teams
- ANA
- away_team_idtext · links to teams
- CHN
- home_scorenumber
- 1
- away_scorenumber
- 6
- day_nighttext
- night
- attendancenumber
- 37042
- duration_minutesnumber
- 154
- game_idtext · unique id
- ANA201604070
- seasonnumber · links to seasons
- 2016
- game_datedate
- 2016-04-07
- game_numbernumber
- 0
- game_typetext
- regular
- venue_idtext · links to venues
- ANA01
- home_team_idtext · links to teams
- ANA
- away_team_idtext · links to teams
- TEX
- home_scorenumber
- 4
- away_scorenumber
- 3
- day_nighttext
- night
- attendancenumber
- 39089
- duration_minutesnumber
- 191
- game_idtext · unique id
- ANA201604080
- seasonnumber · links to seasons
- 2016
- game_datedate
- 2016-04-08
- game_numbernumber
- 0
- game_typetext
- regular
- venue_idtext · links to venues
- ANA01
- home_team_idtext · links to teams
- ANA
- away_team_idtext · links to teams
- TEX
- home_scorenumber
- 3
- away_scorenumber
- 7
- day_nighttext
- night
- attendancenumber
- 35207
- duration_minutesnumber
- 210
- game_idtext · unique id
- ANA201604090
- seasonnumber · links to seasons
- 2016
- game_datedate
- 2016-04-09
- game_numbernumber
- 0
- game_typetext
- regular
- venue_idtext · links to venues
- ANA01
- home_team_idtext · links to teams
- ANA
- away_team_idtext · links to teams
- TEX
- home_scorenumber
- 1
- away_scorenumber
- 4
- day_nighttext
- night
- attendancenumber
- 38106
- duration_minutesnumber
- 173
- game_idtext · unique id
- ANA201604100
- seasonnumber · links to seasons
- 2016
- game_datedate
- 2016-04-10
- game_numbernumber
- 0
- game_typetext
- regular
- venue_idtext · links to venues
- ANA01
- home_team_idtext · links to teams
- ANA
- away_team_idtext · links to teams
- TEX
- home_scorenumber
- 3
- away_scorenumber
- 1
- day_nighttext
- day
- attendancenumber
- 35097
- duration_minutesnumber
- 163
first 6 of 23,168 rows · your queries use all of them
solution.sql
Hints and the answer are always available. Using them counts the question as solved with help.