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

59 votes597 views6 answers
Alter table sql
SQL
0 vote391 views1 answer
Select sql in descending order
SQL
0 vote364 views2 answers
Sql server select first day of previous year
SQL
-1 vote351 views1 answer
Ssms connect with connection string
SQL
0 vote401 views1 answer
MySQL - Enabling the Event Scheduler
SQL
1 vote364 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote389 views1 answer
Sql declare variable single line
SQL
0 vote397 views1 answer
Postgresql print sessions using the database
SQL
1 vote362 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote343 views2 answers
Android sqlite tutorial for beginners
SQL