#   qryBlankStates.sql
#   SQL
#   n6lhv@arrl.net (Wayne Smith)


#   Display the MySQL version
SELECT version();


#  Switch to the correct database
USE uls


#  Extract the records with missing data
SELECT location_state, location_county, COUNT( call_sign ) AS CountOfCallSign
FROM PUBACC_LO
WHERE (location_state='' ) AND NOT (location_county='')
GROUP BY location_state, location_county
;