How many apartments in this table?
select count ( * ) from apartments
Yes.
select count ( * ) from apartments where apt_type_code = 'Flat'
What is the number of apartments whose type code is studio?
select count ( * ) from apartments where apt_type_code = 'Studio'