| Query | Description |
| All_LIC_within_REA | Returns all records from the U700_LICENSE table operating in the REA specified in the query |
| All_LIC_within_REA_FR | Returns all records from the U700_LICENSE table operating in the REA specified in the query and appends frequency information from the U700_FREQUENCY table |
| LIC_for_DBA | Returns all records from the U700_LICENSE table where the DBA name is similar to the one specified in the query |
| LIC_for_DBA_FR | Returns all records from the U700_LICENSE table where the DBA name is similar to the one specified in the query and appends frequency information from the U700_FREQUENCY table. |
| MarketCode | Creates a list of all REAs from the U700_LICENSE tables, along with associated market names |
| U700_FREQUENCY_BandwidthTotal_with_LIC_info |
Joins information from the U700_FREQUENCY table to the U700_LICENSE table and calculates the total bandwidth for each record using the following formula: (LowerBandMax – LowerBandMin) + (UpperBandMax – UpperBandMin) = TotalBandWidth Bandwidth is displayed in the TotalBandWidth column. |