Step 1: f_add_column(points)
game |
date |
team |
score |
high points |
high rebounds |
high assists |
location attendance |
record |
75 |
april 1 |
philadelphia |
l 90 - 115 (ot) |
brandan wright (15) |
brandan wright (11) |
deron williams (7) |
wells fargo center 16695 |
23 - 52 |
76 |
april 3 |
miami |
l 94 - 108 (ot) |
deron williams (18) |
travis outlaw (9) |
deron williams (9) |
prudential center 18711 |
23 - 53 |
77 |
april 5 |
minnesota |
w 107 - 105 (ot) |
brook lopez (30) |
brook lopez (12) |
deron williams (21) |
prudential center 13461 |
24 - 53 |
78 |
april 6 |
detroit |
l 109 - 116 (ot) |
brook lopez (39) |
brook lopez (7) |
jordan farmar (11) |
the palace of auburn hills 14554 |
24 - 54 |
79 |
april 8 |
new york |
l 93 - 116 (ot) |
brook lopez (27) |
jordan farmar (8) |
jordan farmar (9) |
prudential center 18023 |
24 - 55 |
80 |
april 10 |
toronto |
l 92 - 99 (ot) |
brook lopez (35) |
brook lopez (11) |
jordan farmar (7) |
air canada centre 17755 |
24 - 56 |
81 |
april 11 |
charlotte |
l 103 - 105 (ot) |
brook lopez (31) |
dan gadzuric (8) |
jordan farmar (9) |
prudential center 13853 |
24 - 57 |
Step 2: f_select_row(row 2, row 3, row 4, row 5, row 6)
game |
date |
team |
score |
high points |
high rebounds |
high assists |
location attendance |
record |
points |
75 |
april 1 |
philadelphia |
l 90 - 115 (ot) |
brandan wright (15) |
brandan wright (11) |
deron williams (7) |
wells fargo center 16695 |
23 - 52 |
15 |
76 |
april 3 |
miami |
l 94 - 108 (ot) |
deron williams (18) |
travis outlaw (9) |
deron williams (9) |
prudential center 18711 |
23 - 53 |
18 |
77 |
april 5 |
minnesota |
w 107 - 105 (ot) |
brook lopez (30) |
brook lopez (12) |
deron williams (21) |
prudential center 13461 |
24 - 53 |
30 |
78 |
april 6 |
detroit |
l 109 - 116 (ot) |
brook lopez (39) |
brook lopez (7) |
jordan farmar (11) |
the palace of auburn hills 14554 |
24 - 54 |
39 |
79 |
april 8 |
new york |
l 93 - 116 (ot) |
brook lopez (27) |
jordan farmar (8) |
jordan farmar (9) |
prudential center 18023 |
24 - 55 |
27 |
80 |
april 10 |
toronto |
l 92 - 99 (ot) |
brook lopez (35) |
brook lopez (11) |
jordan farmar (7) |
air canada centre 17755 |
24 - 56 |
35 |
81 |
april 11 |
charlotte |
l 103 - 105 (ot) |
brook lopez (31) |
dan gadzuric (8) |
jordan farmar (9) |
prudential center 13853 |
24 - 57 |
31 |
Step 3: f_select_column(game, high points)
game |
date |
team |
score |
high points |
high rebounds |
high assists |
location attendance |
record |
points |
77 |
april 5 |
minnesota |
w 107 - 105 (ot) |
brook lopez (30) |
brook lopez (12) |
deron williams (21) |
prudential center 13461 |
24 - 53 |
30 |
78 |
april 6 |
detroit |
l 109 - 116 (ot) |
brook lopez (39) |
brook lopez (7) |
jordan farmar (11) |
the palace of auburn hills 14554 |
24 - 54 |
39 |
79 |
april 8 |
new york |
l 93 - 116 (ot) |
brook lopez (27) |
jordan farmar (8) |
jordan farmar (9) |
prudential center 18023 |
24 - 55 |
27 |
80 |
april 10 |
toronto |
l 92 - 99 (ot) |
brook lopez (35) |
brook lopez (11) |
jordan farmar (7) |
air canada centre 17755 |
24 - 56 |
35 |
81 |
april 11 |
charlotte |
l 103 - 105 (ot) |
brook lopez (31) |
dan gadzuric (8) |
jordan farmar (9) |
prudential center 13853 |
24 - 57 |
31 |
Step 4: simple_query()
game |
high points |
77 |
brook lopez (30) |
78 |
brook lopez (39) |
79 |
brook lopez (27) |
80 |
brook lopez (35) |
81 |
brook lopez (31) |
Prompting LLM for the final answer... >>>