Table: wtatier_i_tournaments
Columns: tournament
surface
week
winner
finalist
semifinalists

Question: Who was the winner of the Miami tournament where Elena Dementieva was a finalist?
SQL: SELECT "winner" FROM wtatier_i_tournaments WHERE "finalist" = 'elena dementieva' AND "tournament" = 'miami'

Question: Who was the finalist of the hard surface tournament in Miami?
SQL: SELECT "finalist" FROM wtatier_i_tournaments WHERE "surface" = 'hard' AND "tournament" = 'miami'

Question: Who were the semifinalists in the Rome tournament?
SQL: SELECT "semifinalists" FROM wtatier_i_tournaments WHERE "tournament" = 'rome'