Table: astrology_elements
Columns: sign
element
qualities
season_north
season_south

Question: What is the qualities of the sign cancer?
SQL: SELECT "qualities" FROM astrology_elements WHERE "sign" = 'cancer'

Question: What is the sign of the water element with a cold & dry (autumn/earth) north season?
SQL: SELECT "sign" FROM astrology_elements WHERE "season_north" = 'cold & dry (autumn/earth)' AND "element" = 'water'

Question: What is the south season with cold & dry qualities and a cold & wet (winter/water) north season?
SQL: SELECT "season_south" FROM astrology_elements WHERE "qualities" = 'cold & dry' AND "season_north" = 'cold & wet (winter/water)'

Question: What is the south season of the scorpio sign, which has cold & wet qualities?
SQL: SELECT "season_south" FROM astrology_elements WHERE "qualities" = 'cold & wet' AND "sign" = 'scorpio'