( NOTE : ABOVE ADVANTAGE IS WE CAN DISPLAY ONLY WHAT WE NEED THAT THINGS ONLY WE CAN ADD TO QUERY BUT ALL THE INNER QUERIES ARE EXECUTED BUT WE CAN RESTRICT WHAT DISPLAY IN OUTER SUBQUERY) ...
CASE name WHEN 'Low' THEN 24 WHEN 'Medium' THEN 8 ELSE 1 END AS target_response_hrs, CASE name WHEN 'Low' THEN 120 WHEN 'Medium' THEN 48 ELSE 12 END AS target_resolution_hrs ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results