SELECT dbo.”WBSCDCL”.”Group”,
COUNT( dbo.WBSCDCL.ref_num) AS TktCnt,
dbo.”WBSCDCL”.ref_num
FROM dbo.”WBSCDCL”
INNER JOIN dbo.”WBSEDCL_REPORT” ON
dbo.”WBSEDCL_REPORT”.ref_num = dbo.”WBSCDCL”.ref_num
WHERE
dbo.”WBSCDCL”.”Cat” NOT IN (‘%sikkim%’,’%ERP%’)
AND dbo.”WBSCDCL”.”Group” NOT IN (‘%ERP%’)
AND dbo.”WBSEDCL_REPORT”.action_desc LIKE ‘Status changed from ‘Resolved’ to ‘Open’%’
GROUP BY dbo.”WBSCDCL”.ref_num,
dbo.”WBSCDCL”.”Group”
How to expresss in Below code in SQL
dbo.”WBSEDCL_REPORT”.action_desc LIKE ‘Status changed from ‘Resolved’ to ‘Open’%’
Source: New feed
{pubDate}