| Query | Description |
| All_LIC_within_BEA | Returns all records from the L700_LICENSE table that operate within the BEA specified in the query. Query results include all CMA licenses operating within the BEA, as well as BEA licenses. |
| All_LIC_within_BEA_FR | Returns all records from the L700_LICENSE table for the BEA specified, appending frequency information from the L700_FREQUENCY table. Query results include all CMA licenses operating within the BEA, as well as BEA licenses. |
| All_LIC_within_CMA | Returns all records from the L700_LICENSE table that operate within the CMA specified in the query. Query results include all BEA licenses operating within the specified CMA. |
| All_LIC_within_CMA_FR | Returns all records from the L700_LICENSE table that operate within the CMA specified in the query, appending frequency information from the L700_FREQUENCY table. Query results include all BEA licenses operating within the CMA. |
| LIC_for_DBA | Returns all records from the L700_LICENSE table where the DBA name is similar to the one specified in the query. |
| LIC_for_DBA_FR | Returns all records from the L700_LICENSE table where the DBA name is similar to the one specified in the query, appending frequency information from the L700_FREQUENCY table |
| MarketCode | Returns all BEAs from the L700_LICENSE table with associated market names |
| L700_FREQUENCY_Bandwidth_Total with_LIC |
Joins information from the L700_FREQUENCY table to the L700_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. |