#   qryBlankCounties.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_county, location_city, COUNT( call_sign ) AS CountOfCallSign
FROM PUBACC_LO
WHERE (location_county='' ) AND NOT (location_city='')
GROUP BY location_county, location_city
;