daljeetsingh/SQL_Generation

1small_query=""" Tables:2        CREATE TABLE table_name_11 (date VARCHAR, away_team VARCHAR)3 4        Question:5        On what Date did the Away team essendon play?6 7        Answer:"""8long_query="""Tables:9 10CREATE TABLE employees (11    EMPLOYEE_ID decimal(6,0), FIRST_NAME varchar(20),12    LAST_NAME varchar(25), EMAIL varchar(25),13    PHONE_NUMBER varchar(20), HIRE_DATE date,14    JOB_ID varchar(10), SALARY decimal(8,2),15    COMMISSION_PCT decimal(2,2), MANAGER_ID decimal(6,0),16    DEPARTMENT_ID decimal(4,0)17)18CREATE TABLE jobs (19    JOB_ID varchar(10), JOB_TITLE varchar(35),20    MIN_SALARY decimal(6,0), MAX_SALARY decimal(6,0)21)22CREATE TABLE locations (23    LOCATION_ID decimal(4,0), STREET_ADDRESS varchar(40),24    POSTAL_CODE varchar(12), CITY varchar(30),25    STATE_PROVINCE varchar(25), COUNTRY_ID varchar(2)26)27CREATE TABLE countries (28    COUNTRY_ID varchar(2),  COUNTRY_NAME varchar(40),29    REGION_ID decimal(10,0)30)31CREATE TABLE job_history (32    EMPLOYEE_ID decimal(6,0), START_DATE date,33    END_DATE date, JOB_ID varchar(10),34    DEPARTMENT_ID decimal(4,0)35)36CREATE TABLE regions (37    REGION_ID decimal(5,0), REGION_NAME varchar(25)38)39CREATE TABLE departments (40    DEPARTMENT_ID decimal(4,0), DEPARTMENT_NAME varchar(30),41    MANAGER_ID decimal(6,0),LOCATION_ID decimal(4,0)42)43 44Question:45 46For those employees who did not have any job in the past, give me the comparison about the amount of job_id over the job_id , and group by attribute job_id, and list from low to high by the JOB_ID please.47 48Answer:49"""