| Query Name | Description |
| LIC_Expired_after | Finds records in the CELLULAR_LICENSE table where ExpiredDate is after the date entered in the query |
| LIC_Expired_after | Finds records in the CELLULAR_LICENSE table where ExpiredDate is after the date entered in the query |
| LIC_Expired_between | Finds records in the CELLULAR_LICENSE table where ExpiredDate is between the dates entered in the query |
| LIC_For_DBA | Finds records in the CELLULAR_LICENSE table where the DBA name is similar to the name entered in the query |
| LIC_Granted_after | Finds records in the CELLULAR_LICENSE table where GrantDate is after the date entered in the query |
| LIC_Granted_before | Finds records in the CELLULAR_LICENSE table where GrantDate is prior to the date entered in the query |
| LIC_Granted_between | Finds records in the CELLULAR_LICENSE table where GrantDate is between the dates entered in the query |
| LIC_with_MarketName | Attaches market names to the CELLULAR_LICENSE table. The new table is created by joining the CELLULAR_LICENSE table to the CMA table. |