SELECT count(*) FROM chip_model WHERE wifi  =  'No'
Count the number of chip model that do not have wifi.
SELECT count ( * ) FROM chip_model WHERE wifi = 'No '
select count ( * ) from chip_model where wifi = value
Count the number of chip model that do not have wifi .