Is there any way, using the provided DQE, to generate the following query?
SELECT
APPL_BARCODE_TX AS ApplicationBarcode,
APPL_ID AS ApplicationId,
FIRST_NM AS FirstName,
LAST_NM AS LastName,
DE_VAL_DEF_TX AS Status
FROM crsc_app.LK_APPLICATION_STATUS_T lk
LEFT JOIN crsc_app.APPLICATION_T a
USING (APPL_STAT_CD)
JOIN crsc_app.PERSON_T P USING (PERSON_ID )
WHERE lk.DE_VAL_DEF_TX = 'Combat Determination Approved'
MINUS
SELECT APPL_BARCODE_TX AS ApplicationBarcode,
APPL_ID AS ApplicationId,
FIRST_NM AS FirstName,
LAST_NM AS LastName,
DE_VAL_DEF_TX AS Status
FROM crsc_app.LK_APPLICATION_STATUS_T lk
LEFT JOIN crsc_app.APPLICATION_T a USING (APPL_STAT_CD)
JOIN crsc_app.PERSON_T P USING (PERSON_ID )
JOIN crsc_app.dfas_tl_application_t using (appl_id)
ORDER BY 1
