user: ### NOW ANSWER:
Question: What is the Area KM 2 of Rothesay?
Columns: ['Official Name', 'Status', 'Area km 2', 'Population', 'Census Ranking']
Types: ['text', 'text', 'text', 'real', 'text']
Sample row: ['Studholm', 'Parish', '449.43', 3526.0, '891 of 5,008']
SQL:

assistant: SELECT COUNT("Area km 2") FROM "Table" WHERE "Official Name" = 'Rothesay';