Schema: CREATE TABLE manufacturers (founder VARCHAR)
Question: How many companies were created by Andy?
SQL: SELECT COUNT(*) FROM manufacturers WHERE founder = 'Andy'