count sql query with condition

 SELECT count(`user_id`) from `activity_types` where user_id=1096 and sport_id Is null;

Syntax:-

select count('name_of_column') from `name_of_table` condition

Other Exmple

SELECT count('id') from `activity_types` where sport_id is not null and (id=16 or id=32 or id=33 or id=1 or id=34 or id=17);