PNP Confirmation SQL

#-------------------------------------------------------------------------------
# Delivered AND Undelivered  |
#----------------------------

# undelivered
SELECT COUNT(DISTINCT trackingno) AS Undelivered FROM status_details WHERE
LEFT(UpdatedBy,3) = 'ang' AND LEFT(dateupdate,10)= '2019-11-05'
AND undelivered = 'YES' AND NOT ISNULL(ThirdAttemptReason)

# delivered
SELECT COUNT(DISTINCT trackingno) AS Delivered FROM status_details WHERE
LEFT(UpdatedBy,3) = 'ang' AND LEFT(dateupdate,10)= '2019-11-05'
AND delivered = 'YES'

#-------------------------------------------------------------------------------
#  Branch TO Branch  |
#--------------------

# COUNT ALL b2b
SELECT COUNT(DISTINCT TrackingNo) AS B2B_Delivered FROM status_details
WHERE LEFT(UpdatedBy, 3) = 'ang'          # branch
AND LEFT(dateupdate, 10) = '2019-11-05'   # dated
AND delivered = 'YES'                     # dvl
AND TrackingNo REGEXP "^[B]"

# SELECT ALL b2b
SELECT * FROM status_details WHERE TrackingNo REGEXP "^[B]"
AND LEFT(UpdatedBy, 3) = 'ang'
AND LEFT(dateupdate, 10) = '2019-11-05'
AND delivered = 'YES'

#-------------------------------------------------------------------------------
#  HSBC - SOA    |
#----------------

# SELECT ALL HSBC-SOA
SELECT * FROM status_details WHERE TrackingNo REGEXP "^[A-Z0-9]{17,}"
AND LEFT(UpdatedBy, 3) = 'ang'
AND LEFT(dateupdate, 10) = '2019-11-05'
AND delivered = 'YES'

#--------------------------------------------------------------------------------
#  AC / CSU / EP   |
#------------------

# SELECT ALL AC / CSU / EP
SELECT * FROM status_details WHERE TrackingNo REGEXP "^[0-9]{7}"
AND LEFT(UpdatedBy, 3) = 'ang'
AND LEFT(dateupdate, 10) = '2019-11-05'
AND delivered = 'YES'

#--------------------------------------------------------------------------------
#  No Record Found   |
#--------------------

# COUNT no record found
SELECT COUNT(DISTINCT trackingno) AS Delivered FROM status_details_no_record_found WHERE
LEFT(UpdatedBy,3) = 'ang'
AND LEFT(dateupdate,10)= '2019-11-05'
AND delivered = 'YES'

# SELECT ALL no record found
SELECT * FROM status_details_no_record_found WHERE
LEFT(UpdatedBy, 3) = 'ang'
AND LEFT(dateupdate, 10) = '2019-11-05'
AND delivered = 'YES'

#--------------------------------------------------------------------------------