| Query Name | Description |
| All_LIC_within_BEA | Returns all records from the AWS_LICENSE table that operate within the BEA specified in the query. The query returns all REA licenses (frequency block C) as well as BEA licenses (frequency blocks A and E). |
| All_LIC_within_BEA_FR | Returns records from the AWS_LICENSE table that operate within the BEA specified in the query and appends corresponding frequency information from the AWS_FREQUENCY table. Returns all REA licenses (frequency block C) as well as BEA licenses (frequency blocks A and E). |
| All_LIC_within_REA | Returns all records from the AWS_LICENSE table that operate within the REA specified in the query. The query returns REA licenses (frequency blocks A and E) as well as REA licenses (frequency block C). |
| All_LIC_within_REA_FR | Returns records from the AWS_LICENSE table that operate within the REA specified in the query and appends corresponding frequency information from AWS_FREQUENCY table. Returns all BEA licenses (frequency blocks A and E) as well as REA licenses (frequency block C). |
| LIC_for_DBA | Returns records from the AWS_LICENSE table where the DBA name is similar to the named entered in the query |
| LIC_for_DBA_FR | Returns records from the AWS_LICENSE table where the DBA name is similar to the name entered in the query and appends associated frequency information from the AWS_FREQUENCY table |
| MarketCode | Returns a list of all REAs and BEAs in the AWS_LICENSE table, along with their respective market codes |
| AWS_FREQUENCY_BandwidthTotal_with_LIC |
Joins information from the AWS_FREQUENCY table to the AWS_LICENSE table and calculates the total bandwidth for each record using the following formula:
Results are displayed in the TotalBandWidth column. |