SELECT count(*) FROM airports WHERE name LIKE '%International%'
Find the number of airports whose name contain the word 'International'.
SELECT count ( * ) FROM airports WHERE name LIKE ' % International % '
select count ( * ) from airports where name like value
Find the number of airports whose name contain the word 'International ' .