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 vote406 views1 answer
Oracle columns table
SQL
0 vote342 views1 answer
How to create a new db from dumb file mysql
SQL
3 votes360 views1 answer
Oracle list privileges
SQL
0 vote348 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
1 vote379 views1 answer
Postgres see sequence current state
SQL
2 votes282 views1 answer
Sql group by different columns
SQL
4 votes323 views3 answers
Count with where
SQL
0 vote320 views1 answer
Select last 2 characters sql
SQL
0 vote377 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
2 votes353 views2 answers
Mysql add hours to time field
SQL