SELECT count(*) FROM airports WHERE name LIKE '%International%'
How many airports' names have the word Interanation in them?
SELECT count ( * ) FROM airports WHERE name LIKE ' % International % '
select count ( * ) from airports where name like value
How many airports ' names have the word Interanation in them ?