Table: auto_uk_companies
Columns: company
parent_company
parent_headquarters
plant
models_produced
production_latest_figures

Question: what is the company with the parent company wrightbus?
SQL: SELECT "company" FROM auto_uk_companies WHERE "parent_company" = 'Wrightbus'

Question: what is the name ofhte company where the plant is in burnaston?
SQL: SELECT "company" FROM auto_uk_companies WHERE "plant" = 'Burnaston'

Question: what models are produced where the plant is scarborough?
SQL: SELECT "models_produced" FROM auto_uk_companies WHERE "plant" = 'Scarborough'

Question: how many models produced where the plant is castle bromwich?
SQL: SELECT COUNT("models_produced") FROM auto_uk_companies WHERE "plant" = 'Castle Bromwich'

Question: what is the production where the parent company is ariel?
SQL: SELECT "production_latest_figures" FROM auto_uk_companies WHERE "parent_company" = 'Ariel'