Table: tyre_specs
Columns: compound_name
colour
tread
driving_conditions
dry_type
grip
durability

Question: What compound is yellow?
SQL: SELECT "compound_name" FROM tyre_specs WHERE "colour" = 'yellow'

Question: What grip has a dry option?
SQL: SELECT "grip" FROM tyre_specs WHERE "dry_type" = 'option'

Question: What color is the super-soft compound?
SQL: SELECT "colour" FROM tyre_specs WHERE "compound_name" = 'super-soft'