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

16 votes204 views6 answers
Mysql find and replace
SQL
2 votes228 views1 answer
Install postgresql centos 5
SQL
4 votes210 views1 answer
Alter session set nls_date_format
SQL
1 vote246 views1 answer
Oracle drop temporary table
SQL
4 votes198 views1 answer
Adding data to table in sql python
SQL
0 vote216 views1 answer
Raiserror with nowait
SQL
1 vote199 views1 answer
Multiple count in sql
SQL
25 votes209 views5 answers
Uninstall mysql ubuntu
SQL
15 votes201 views2 answers
How to know the username of postgresql
SQL
0 vote265 views1 answer
Mysl like insert a variable
SQL