Using count(*) in subqueries

MS SQL:

select P.programa_id,P.pavadinimas,
P.licenziju_kiekis,A.numCount,
P.data,P.administratorius
from programos P join (select programa_ID,Count(programa_ID) as numCount
from P_sandelys
group by programa_ID) A on (A.programa_id=P.programa_id)

Geros dienos!