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 vote349 views1 answer
Mysql where don't have string
SQL
8 votes314 views1 answer
Oracle add month
SQL
13 votes336 views2 answers
Sql online compiler
SQL
0 vote345 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
5 votes343 views2 answers
Sql conn
SQL
1 vote327 views1 answer
Oracle create as select
SQL
0 vote311 views1 answer
Sql get table last modified time
SQL
2 votes361 views1 answer
Oracle insert or update
SQL
2 votes306 views1 answer
Match in sql server
SQL
0 vote336 views1 answer
Hibernate show sql xml property
SQL