Step 1: f_select_row(row 2, row 5, row 6)
player |
team |
matches |
wickets |
average |
best bowling |
ray lindwall |
australia |
5 |
27 |
19.62 |
6 / 20 |
bill johnston |
australia |
5 |
27 |
23.33 |
5 / 36 |
alec bedser |
england |
5 |
18 |
38.22 |
4 / 81 |
keith miller |
australia |
5 |
13 |
23.15 |
4 / 125 |
ernie toshack |
australia |
4 |
11 |
33.09 |
5 / 40 |
norman yardley |
england |
5 |
9 |
22.66 |
2 / 32 |
jim laker |
england |
3 |
9 |
52.44 |
4 / 138 |
Step 2: f_select_column(player, team, wickets)
player |
team |
matches |
wickets |
average |
best bowling |
alec bedser |
england |
5 |
18 |
38.22 |
4 / 81 |
norman yardley |
england |
5 |
9 |
22.66 |
2 / 32 |
jim laker |
england |
3 |
9 |
52.44 |
4 / 138 |
Step 3: f_group_column(team)
Step 4: simple_query()
player |
team |
wickets |
alec bedser |
england |
18 |
norman yardley |
england |
9 |
jim laker |
england |
9 |
Group Sub Table
Prompting LLM for the final answer... >>>