Schema: CREATE TABLE company (Headquarters VARCHAR)
Question: How many companies are headquartered in the US?
SQL: SELECT COUNT(*) FROM company WHERE Headquarters = 'USA'