Among the cars produced in 1975, provide IDs, names, and producing countries of the cars with the maximum number of cylinders.
produced in 1975 refers to model_year = 1975; names refers to car_name; producing countries refers to country; the maximum number of cylinders refers to max(cylinders)
SELECT T1.ID, T1.car_name, T3.country FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country WHERE T2.model_year = 1975 ORDER BY T1.cylinders DESC LIMIT 1
database name:db_id cars
country table country Cols: origin dtype integer, country dtype text, 
price table price Cols: ID dtype integer, price dtype real, 
data table data Cols: ID dtype integer, mileage per gallon dtype real, number of cylinders dtype integer, displacement dtype real, horse power dtype integer, weight dtype integer, acceleration dtype real, model dtype integer, car name dtype text, 
production table production Cols: ID dtype integer, model year dtype integer, country dtype integer, 
