SELECT count(*) FROM stadium WHERE country != 'Russia'
How many stadiums are not in country "Russia"?
SELECT count ( * ) FROM stadium WHERE country ! = 'Russia '
select count ( * ) from stadium where country ! = value
How many stadiums are not in country `` Russia '' ?