79245777

Date: 2024-12-02 22:32:37
Score: 3
Natty:
Report link

Anasbaltar

----------SELECT ID, SUM( CASE WHEN [Status] = 'Good' THEN 1 ELSE 0 END ) * 1.0 / COUNT(*), FROM TABLE WHERE ID IN ('ID1','ID2') GROUP BY ID

Reasons:
  • Low length (1):
  • No code block (0.5):
  • Filler text (0.5): ----------
  • Low reputation (1):
Posted by: Anas Baltar