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

0 vote442 views1 answer
Power bi connect to postgresql
SQL
2 votes196 views1 answer
Oracle apex list connected users
SQL
0 vote206 views1 answer
Hibernate show sql xml property
SQL
3 votes288 views2 answers
Mysql user permission database
SQL
0 vote185 views1 answer
Oracle tablespace autoextend
SQL
0 vote199 views1 answer
Import sql in postgresql
SQL
3 votes198 views1 answer
Sql insert inserted id
SQL
1 vote205 views1 answer
Delete specific row in sql
SQL
0 vote188 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote194 views1 answer
Sql tabelle erstellen
SQL