

select count(hitid) AS "pi.dk" from hit where CustomerID
 = (select customerid from customer where Customertext='pi.dk')
   
