In the train.jsonl the first record under the seq->conds attribute it says 3 but it should say 0 instead.
For reference following is the object
{'phase': 1, 'table_id': '1-1000181-1', 'question': 'Tell me what the notes are for South Australia ', 'sql': {'sel': 5, 'conds': [[3, 0, 'SOUTH AUSTRALIA']], 'agg': 0}}
and following is the header for the particular table
["State/territory", "Text/background colour", "Format", "Current slogan", "Current series", "Notes"]
Intuitively it should choose State/territory column in the where clause
Following is the translated query
SELECT Notes AS result FROM table_1_1000181_1 WHERE Current slogan = 'south australia';
tell me what the notes are for south australia
In the train.jsonl the first record under the seq->conds attribute it says 3 but it should say 0 instead.
For reference following is the object {'phase': 1, 'table_id': '1-1000181-1', 'question': 'Tell me what the notes are for South Australia ', 'sql': {'sel': 5, 'conds': [[3, 0, 'SOUTH AUSTRALIA']], 'agg': 0}}
and following is the header for the particular table ["State/territory", "Text/background colour", "Format", "Current slogan", "Current series", "Notes"]
Intuitively it should choose State/territory column in the where clause
Following is the translated query SELECT Notes AS result FROM table_1_1000181_1 WHERE Current slogan = 'south australia'; tell me what the notes are for south australia