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

0 vote162 views1 answer
Sql out file formate
SQL
2 votes213 views1 answer
How to create sql database
SQL
5 votes141 views2 answers
Mysqldump password
SQL
1 vote166 views1 answer
Postgresql not in
SQL
0 vote164 views3 answers
Mysql regex replace
SQL
0 vote145 views1 answer
Implizite joins sql
SQL
10 votes161 views4 answers
Mysql one week ago
SQL
7 votes164 views5 answers
Max 3 salary in sql
SQL
0 vote150 views1 answer
Oracle exchange partition
SQL
0 vote150 views1 answer
Create domain sql
SQL