Step 1: f_select_row(row 2, row 5, row 12, row 14, row 15, row 16, row 17, row 19, row 21)
year |
class |
team |
points |
wins |
1959 |
125cc |
ducati |
2 |
0 |
1960 |
125cc |
mv agusta |
0 |
0 |
1960 |
250cc |
aermacchi |
2 |
0 |
1960 |
350cc |
norton |
0 |
0 |
1960 |
500cc |
norton |
0 |
0 |
1961 |
250cc |
aermacchi |
0 |
0 |
1961 |
500cc |
norton |
3 |
0 |
1962 |
125cc |
honda |
2 |
0 |
1962 |
250cc |
honda |
8 |
0 |
1963 |
50cc |
kreidler |
9 |
0 |
1963 |
350cc |
norton |
0 |
0 |
1964 |
250cc |
paton |
6 |
0 |
1965 |
250cc |
aermacchi |
1 |
0 |
1965 |
350cc |
aermacchi |
0 |
0 |
1966 |
250cc |
aermacchi |
4 |
0 |
1966 |
350cc |
aermacchi |
11 |
0 |
1967 |
250cc |
aermacchi |
0 |
0 |
1967 |
350cc |
aermacchi |
11 |
0 |
1968 |
500cc |
linto |
9 |
0 |
1969 |
350cc |
aermacchi |
0 |
0 |
1969 |
500cc |
linto |
15 |
1 |
1970 |
250cc |
aermacchi |
4 |
0 |
1970 |
500cc |
linto |
30 |
0 |
1971 |
125cc |
derbi |
4 |
0 |
1971 |
250cc |
suzuki |
0 |
0 |
1971 |
500cc |
linto |
29 |
1 |
1971 |
500cc |
mv agusta |
29 |
1 |
1972 |
350cc |
mv agusta |
4 |
0 |
1972 |
500cc |
mv agusta |
87 |
1 |
Step 2: f_select_column(team, wins)
year |
class |
team |
points |
wins |
1960 |
250cc |
aermacchi |
2 |
0 |
1961 |
250cc |
aermacchi |
0 |
0 |
1965 |
250cc |
aermacchi |
1 |
0 |
1966 |
250cc |
aermacchi |
4 |
0 |
1966 |
350cc |
aermacchi |
11 |
0 |
1967 |
250cc |
aermacchi |
0 |
0 |
1967 |
350cc |
aermacchi |
11 |
0 |
1969 |
350cc |
aermacchi |
0 |
0 |
1970 |
250cc |
aermacchi |
4 |
0 |
Step 3: f_group_column(team)
Step 4: simple_query()
team |
wins |
aermacchi |
0 |
aermacchi |
0 |
aermacchi |
0 |
aermacchi |
0 |
aermacchi |
0 |
aermacchi |
0 |
aermacchi |
0 |
aermacchi |
0 |
aermacchi |
0 |
Group Sub Table
Prompting LLM for the final answer... >>>