Writing a query to COUNT all the services involving a particular
select count(distinct service_id)
from staff
where staff_firstname = 'Gary'
  and staff_surname = 'Crowley';


The distinct is only necessary if your database design allows to assign the same service multiple times to the same staff member.