Rails sql query converstion

SmsMessage.where(
        sms_campaign_id: sms_campaign_ids
      ).select(
        "sum(CASE WHEN sms_messages.status = 1 THEN 1 ELSE 0 END) as enqueued_count",
        "sum(CASE WHEN sms_messages.status = 2 THEN 1 ELSE 0 END) as delivered_count",
        "sum(CASE WHEN sms_messages.status = 3 THEN 1 ELSE 0 END) as replies_count",
        "sum(CASE WHEN sms_messages.status = 4 THEN 1 ELSE 0 END) as failed_count",
        "sum(CASE WHEN sms_messages.status IN (1,2,4) THEN 1 ELSE 0 END) as sends_count",
        "count(id) as total_messages_count"
      )

Source: scuttle.io

Similar codes

1 vote264 views1 answer
Is sql fast
SQL
2 votes266 views1 answer
Oracle current date without time
SQL
0 vote257 views2 answers
Php convert dbf to mysql
SQL
14 votes274 views3 answers
Oracle sql limit results
SQL
2 votes251 views1 answer
Docker run postgres locally
SQL
0 vote259 views1 answer
Find invalid datetime field
SQL
0 vote257 views1 answer
Call function sql oracle
SQL
0 vote255 views1 answer
Initcap in sql
SQL
-1 vote253 views3 answers
Check table exist postgresql
SQL
0 vote255 views1 answer
Mysql workbench procedure
SQL