Table: rowing_2008_womens_coxless
Columns: rank
rowers
country
time
notes

Question: Who is the rower from Canada?
SQL: SELECT "rowers" FROM rowing_2008_womens_coxless WHERE "country" = 'canada'

Question: What is the sum of the rank of the rower with an r note from Australia?
SQL: SELECT SUM("rank") FROM rowing_2008_womens_coxless WHERE "notes" = 'r' AND "country" = 'australia'

Question: What is the country with a rank less than 2?
SQL: SELECT "country" FROM rowing_2008_womens_coxless WHERE "rank" < 2