Task: Text to Code
Input (English): What is the smallest weight of the car produced with 8 cylinders on 1974?
Output (English): SELECT Weight FROM CARS_DATA WHERE Cylinders  =  4 AND YEAR  =  1974 ORDER BY Weight ASC LIMIT 1