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

1 vote120 views1 answer
Select inside insert query
SQL
0 vote101 views1 answer
Postgresql create table with boolean column
SQL
0 vote108 views1 answer
Sql doesn't contain
SQL
0 vote104 views1 answer
Postgres drop type
SQL
0 vote98 views1 answer
Mariadb used space
SQL
5 votes59 views1 answer
Postgres upsert
SQL
12 votes92 views4 answers
SQL Where
SQL
-1 vote114 views1 answer
Module operator in oracle sql
SQL
0 vote114 views1 answer
Mysql error 1251
SQL
0 vote101 views2 answers
Update information in a mysql column
SQL