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 vote126 views1 answer
Get all employees if name ends with in sql
SQL
0 vote116 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote80 views1 answer
Now() -1 mysql
SQL
1 vote119 views1 answer
How to select random rows from table
SQL
2 votes124 views1 answer
Sql column values comma separated
SQL
0 vote133 views1 answer
SQL server datetime compare
SQL
0 vote135 views1 answer
Add sqlcmd to path linux
SQL
0 vote127 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
1 vote196 views1 answer
Primary key reset in SQL database
SQL
2 votes170 views1 answer
Orcale index size
SQL