Table: viking_emerald
Columns: ship_name
year_built
length
crew
guests
staterooms
comments

Question: What is the sum of staterooms in with a year buit of 2008, and a crew less than 28?
SQL: SELECT SUM("staterooms") FROM viking_emerald WHERE "year_built" = 2008 AND "crew" < 28

Question: What is the total for guests with a ship name of rv indochina, and a crew smaller than 28?
SQL: SELECT COUNT("guests") FROM viking_emerald WHERE "ship_name" = 'rv indochina' AND "crew" < 28