Specifications

Enumerating
SELECT DISTINCT STATE FROM LOGBOOK WHERE QSL_RCVD='Y' AND (DXCC = 291 OR DXCC =
110 OR DXCC = 6) AND STATE <> ' ' ORDER BY STATE
Valid QSOs for the WAS
SELECT * FROM LOGBOOK WHERE QSL_RCVD='Y' AND (DXCC = 291 OR DXCC = 110 OR DXCC =
6) AND STATE <> ' ' ORDER BY STATE< /FONT>
Enumerating a DXCC with QRP condition (10 w)
SELECT DISTINCT DXCC FROM LOGBOOK WHERE QSL_RCVD = 'Y' AND TX_PWR < '10'
Enumerating the DXCC Millennium award
The DXCC 2000 Millennium Award rewards QSOs made with more than entities of the ARRL
DXCC List within the Year 2000. Contacts may consist of any combination of bands or modes
SELECT DISTINCT DXCC FROM LOGBOOK WHERE QSL_RCVD = 'Y' AND DATE_ON >=
#01/01/2000# AND DATE_ON <= #12/31/2000# ORDER BY DXCC
Page 282