select y.*,
case
when Sub_count <=3 & (cast(Submitted_UW_Date as date) = cast(LAST_WEEKDAY_DATE as Date)-1) then "1 Day"
when Sub_count <=1 & Submitted_UW_Date = LAST_WEEKDAY_DATE then "1 Day"
When Sub_count >3 & Submitted_UW_Date = LAST_WEEKDAY_DATE-1 then "2 Days"
else "Days Exceed"
end as Days
from (select count(submitted_UW_Date) as Sub_count from dbo.Encompass_Main where Cond_Approval_Date is null)y, Encompass_Main, DailyStatus where Submitted_UW_Date= LAST_WEEKDAY_DATE