question

SELECT DISTRIBUTOR , NEW_PROD , DISCONTINUE FROM ( SELECT DISTRIBUTOR = ( SELECT distributor FROM InventoryReportDB.dbo.DAILY_INVENTORY_DATA GROUP BY distributor ) , NEW_PROD = ( SELECT COUNT(*) NEW_PROD FROM InventoryReportDB.dbo.DAILY_INVENTORY_DATA INV WHERE NOT EXISTS ( SELECT 'x' FROM Amazon.dbo.FlatTableProducts az WHERE LTRIM(RTRIM(az.DistributorSKU)) = INV.ITEM_Number AND Distributor = LTRIM(RTRIM(INV.Distributor)) ) GROUP BY distributor ) , DISCONTINUE = ( SELECT COUNT(*) DISCONTINUE FROM Amazon.dbo.FlatTableProducts az WHERE Distributor IN ( 'Alpha Shirt', 'Bodek & Rhodes', 'Sanmar', 'Tri-Mountain' ) AND NOT EXISTS ( SELECT 'x' FROM InventoryReportDB.dbo.DAILY_INVENTORY_DATA INV WHERE az.DistributorSKU = LTRIM(RTRIM(INV.ITEM_Number)) AND Distributor = LTRIM(RTRIM(INV.Distributor)) ) GROUP BY Distributor ) ) SUMMARY