79245809

Date: 2024-12-02 22:53:43
Score: 0.5
Natty:
Report link

Try this query and let me know if this resolve your issue

‘ SELECT ID, COUNT(CASE WHEN [Status] = 'Good' THEN 1 END) AS Good, SUM(COUNT(*)) OVER () AS Total FROM TABLE WHERE ID IN ('ID1', 'ID2') GROUP BY ID; ’

Reasons:
  • Whitelisted phrase (-1): Try this
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: rahul singh Chauhan