awslabs / awslabs/gap-text2sql

The JOIN table part of the output SQL does not contain ON clauses.

Open
#8 4 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
109
Forks
25
PR merge metrics
No merged PRs in 30d

Description

Hello,
I found the output sql does not contain ON clauses.
For example,
"question": "Show the stadium name and the number of concerts in each stadium."
"predicted": "SELECT stadium.Name, Count(*) FROM stadium JOIN concert GROUP BY stadium.Stadium_ID"
"gold": "SELECT T2.name , count(*) FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id GROUP BY T1.stadium_id"
I want to know how to get the on clauses "ON T1.stadium_id = T2.stadium_id".
Thank you.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.