Table: iceland_signs
Columns: type_of_sign
shape
border
background_colour
text_symbol

Question: Which sign has a red border and a warning sign?
SQL: SELECT "text_symbol" FROM iceland_signs WHERE "border" = 'red' AND "type_of_sign" = 'warning'

Question: Which sign had a yellow background and a triangular shape?
SQL: SELECT "border" FROM iceland_signs WHERE "background_colour" = 'yellow' AND "shape" = 'triangular'

Question: Which sign has a red border?
SQL: SELECT "text_symbol" FROM iceland_signs WHERE "border" = 'red'

Question: Which color is the background of the mandatory instructions?
SQL: SELECT "background_colour" FROM iceland_signs WHERE "type_of_sign" = 'mandatory instructions'

Question: What is the color of the background of the white border and sign of information?
SQL: SELECT "background_colour" FROM iceland_signs WHERE "border" = 'white' AND "type_of_sign" = 'information'