Step 1: f_add_column(last month)
| name |
total |
first |
last |
highest rank |
| kotonishiki |
34 |
september 1990 |
september 1999 |
sekiwake |
| kaiō |
32 |
may 1994 |
july 2000 |
ōzeki |
| musōyama |
31 |
march 1994 |
september 2000 |
ōzeki |
| hasegawa |
30 |
november 1965 |
september 1974 |
sekiwake |
| kotomitsuki |
30 |
january 2001 |
july 2007 |
ōzeki |
| akinoshima |
27 |
november 1988 |
september 2000 |
sekiwake |
| takamiyama |
27 |
november 1969 |
september 1982 |
sekiwake |
| takatōriki |
26 |
may 1991 |
may 2000 |
sekiwake |
| wakanosato |
26 |
november 2000 |
september 2005 |
sekiwake |
| daikirin |
22 |
november 1966 |
september 1970 |
ōzeki |
| tochiazuma ii |
22 |
july 1997 |
january 2005 |
ōzeki |
| kisenosato |
22 |
july 2006 |
september 2011 |
ōzeki |
Step 2: f_select_row(row 0, row 3, row 6, row 11)
| name |
total |
first |
last |
highest rank |
last month |
| kotonishiki |
34 |
september 1990 |
september 1999 |
sekiwake |
september |
| kaiō |
32 |
may 1994 |
july 2000 |
ōzeki |
july |
| musōyama |
31 |
march 1994 |
september 2000 |
ōzeki |
september |
| hasegawa |
30 |
november 1965 |
september 1974 |
sekiwake |
september |
| kotomitsuki |
30 |
january 2001 |
july 2007 |
ōzeki |
july |
| akinoshima |
27 |
november 1988 |
september 2000 |
sekiwake |
september |
| takamiyama |
27 |
november 1969 |
september 1982 |
sekiwake |
september |
| takatōriki |
26 |
may 1991 |
may 2000 |
sekiwake |
may |
| wakanosato |
26 |
november 2000 |
september 2005 |
sekiwake |
september |
| daikirin |
22 |
november 1966 |
september 1970 |
ōzeki |
september |
| tochiazuma ii |
22 |
july 1997 |
january 2005 |
ōzeki |
january |
| kisenosato |
22 |
july 2006 |
september 2011 |
ōzeki |
september |
Step 3: f_select_column(total, last, last month)
| name |
total |
first |
last |
highest rank |
last month |
| kotonishiki |
34 |
september 1990 |
september 1999 |
sekiwake |
september |
| hasegawa |
30 |
november 1965 |
september 1974 |
sekiwake |
september |
| takamiyama |
27 |
november 1969 |
september 1982 |
sekiwake |
september |
| kisenosato |
22 |
july 2006 |
september 2011 |
ōzeki |
september |
Step 4: f_group_column(last month)
Step 5: simple_query()
| total |
last |
last month |
| 34 |
september 1999 |
september |
| 30 |
september 1974 |
september |
| 27 |
september 1982 |
september |
| 22 |
september 2011 |
september |
Group Sub Table
| last month |
Count |
| september |
4 |
Prompting LLM for the final answer... >>>