Skip to content

Instantly share code, notes, and snippets.

View ham_stat.sql
-- Total number of active callsigns for individuals
select count(*)
from dbo.pubacc_am am
join dbo.pubacc_hd hd on am.unique_system_identifier = hd.unique_system_identifier
join dbo.pubacc_en en on en.unique_system_identifier = hd.unique_system_identifier
where en.applicant_type_code = 'I' and hd.license_status = 'A'
-- Number of active 2X2 vanity callsigns for individuals
-- See query in next section