Service level target coverage (Bev. Product/Product with no Target Service Level)

SELECT
    loc.LOCID,
    loc.LOCREGION,
    p.PLANTNAME,
    p.COUNTRYKEY,
    dtd.TARGETSERVICELEVEL,
    dip.PRDID,
    dip.PRDDESCR,
    dil.ZINVENTORYPROGRAM,
    dil.LASTMODIFIEDDATE
FROM DL_IBP_LOCATION loc
JOIN dbo.DL_IBP_PLANT p
    ON loc.LOCID = p.PLANT
JOIN dbo.DL_IBP_DEMANDSTREAM dtd
    ON loc.LOCID = dtd.LOCID
JOIN dbo.DL_IBP_PRODUCT dip ON dip.PRDID = dtd.PRDID
JOIN dbo.DL_IBP_LOCPROD dil ON dil.PRDID = dip.PRDID
WHERE dtd.TARGETSERVICELEVEL IS NULL
    OR dtd.TARGETSERVICELEVEL IN ('0', '0.5', '<Null>');