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

7 votes283 views1 answer
Sql pagination oracle
SQL
0 vote291 views1 answer
Mysql zerofill
SQL
10 votes329 views4 answers
Sql server pagination
SQL
3 votes303 views1 answer
How to add unique constraint in mysql table
SQL
0 vote339 views1 answer
Reset a table's identity column and remove test records
SQL
21 votes269 views3 answers
Sql average
SQL
9 votes268 views2 answers
Sql limit order by
SQL
0 vote294 views1 answer
List in one column mysql
SQL
1 vote264 views2 answers
Sql select only first occurrence
SQL
19 votes257 views6 answers
Laravel sql query
SQL