Table: pilsotas
Columns: name
stories
height
built
purpose
status

Question: What is the year built of the home with a built status and a 42 m. height?
SQL: SELECT "built" FROM pilsotas WHERE "status" = 'built' AND "height" = '42 m.'

Question: What is the height of the home with stories greater than 22 and built in 2009?
SQL: SELECT "height" FROM pilsotas WHERE "stories" > 22 AND "built" = '2009'

Question: What is the highest number of stories in homes with a height of 42 m.?
SQL: SELECT MAX("stories") FROM pilsotas WHERE "height" = '42 m.'