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

1 vote137 views1 answer
Oracle list datafiles in tablespace
SQL
7 votes136 views2 answers
What is sql clause
SQL
1 vote145 views3 answers
Nth highest salary
SQL
-1 vote129 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote137 views1 answer
Mysql bash execute sql file
SQL
0 vote135 views1 answer
Psql attribute cannot login
SQL
0 vote145 views1 answer
New rails app with mysql
SQL
0 vote132 views1 answer
Composit key in sql
SQL
1 vote129 views1 answer
Oracle sql create view
SQL
1 vote132 views1 answer
Order by oracle
SQL