example_queries.py

small_query=""" Tables:
        CREATE TABLE table_name_11 (date VARCHAR, away_team VARCHAR)

        Question:
        On what Date did the Away team essendon play?

        Answer:"""
long_query="""Tables:

CREATE TABLE employees (

    EMPLOYEE_ID decimal(6,0),

    FIRST_NAME varchar(20),

    LAST_NAME varchar(25),

    EMAIL varchar(25),

    PHONE_NUMBER varchar(20),

    HIRE_DATE date,

    JOB_ID varchar(10),

    SALARY decimal(8,2),

    COMMISSION_PCT decimal(2,2),

    MANAGER_ID decimal(6,0),

    DEPARTMENT_ID decimal(4,0)

)



CREATE TABLE jobs (

    JOB_ID varchar(10),

    JOB_TITLE varchar(35),

    MIN_SALARY decimal(6,0),

    MAX_SALARY decimal(6,0)

)



CREATE TABLE locations (

    LOCATION_ID decimal(4,0),

    STREET_ADDRESS varchar(40),

    POSTAL_CODE varchar(12),

    CITY varchar(30),

    STATE_PROVINCE varchar(25),

    COUNTRY_ID varchar(2)

)



CREATE TABLE countries (

    COUNTRY_ID varchar(2),

    COUNTRY_NAME varchar(40),

    REGION_ID decimal(10,0)

)



CREATE TABLE job_history (

    EMPLOYEE_ID decimal(6,0),

    START_DATE date,

    END_DATE date,

    JOB_ID varchar(10),

    DEPARTMENT_ID decimal(4,0)

)



CREATE TABLE regions (

    REGION_ID decimal(5,0),

    REGION_NAME varchar(25)

)



CREATE TABLE departments (

    DEPARTMENT_ID decimal(4,0),

    DEPARTMENT_NAME varchar(30),

    MANAGER_ID decimal(6,0),

    LOCATION_ID decimal(4,0)

)



Question:

For 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.



Answer:
            """