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

6 votes146 views2 answers
Postgresql database url
SQL
17 votes165 views6 answers
MySQL ORDER BY
SQL
24 votes148 views6 answers
Replace mysql
SQL
1 vote163 views2 answers
Mysql does sentance contain word
SQL
1 vote143 views1 answer
Mysql decimal allow negative values?
SQL
3 votes144 views2 answers
Truncate all tables
SQL
0 vote143 views1 answer
Excel export from sql using python
SQL
10 votes262 views4 answers
Mysql if else
SQL
2 votes183 views1 answer
Username sql
SQL
2 votes125 views1 answer
Mysql list users on ubuntu
SQL