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 vote371 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote227 views2 answers
Mysql cast to varchar
SQL
1 vote214 views1 answer
Oracle extract minute from date
SQL
0 vote328 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
-2 votes227 views3 answers
How to fetch first 10 rows in sql
SQL
1 vote174 views1 answer
Postgresql how to show table names
SQL
0 vote199 views1 answer
Mysql config address
SQL
1 vote170 views1 answer
Mysql list bigger table
SQL
1 vote166 views1 answer
Right outer vs left outer join
SQL
1 vote162 views2 answers
Mysql filter by date mount
SQL