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 vote211 views1 answer
Drop domain postgresql
SQL
2 votes204 views5 answers
Alter table primary key postgresql
SQL
0 vote224 views1 answer
Create schema sql server
SQL
0 vote235 views2 answers
Mysql dump database tables only
SQL
0 vote227 views1 answer
Select top values sql
SQL
0 vote203 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote216 views1 answer
Postgres truncate with cascade
SQL
0 vote204 views1 answer
Postgresql conectar
SQL
0 vote221 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote210 views1 answer
Mod in sql
SQL