SELECT count(*) FROM company WHERE Headquarters  =  'USA'
How many companies are headquartered in the US?
SELECT count ( * ) FROM company WHERE Headquarters = 'USA '
select count ( * ) from company where headquarters = value
How many companies are headquartered in the US ?