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

2 votes123 views1 answer
Install postgresql centos 5
SQL
0 vote141 views1 answer
Sqlite schema structure of a relational database
SQL
1 vote98 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote99 views1 answer
Mysql multiple group by
SQL
0 vote140 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote112 views2 answers
Athena drop partition
SQL
0 vote99 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote102 views1 answer
Search column name sql
SQL
0 vote66 views1 answer
Java spring jdbc connect to postgresql
SQL
0 vote134 views1 answer
Select top values sql
SQL