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

3 votes193 views1 answer
Sql case update
SQL
5 votes209 views1 answer
Get table columns from sql
SQL
0 vote203 views1 answer
Typeorm raw sql
SQL
0 vote189 views1 answer
Postgres sql alter table delete row
SQL
0 vote205 views1 answer
Alter table change default
SQL
1 vote197 views1 answer
Duplicating a MySQL table with all the data Command
SQL
-1 vote143 views1 answer
Mysql how to set update or create
SQL
0 vote194 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote204 views1 answer
Mariadb cast to int
SQL
0 vote152 views1 answer
Copy table dbeaver
SQL