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

11 votes255 views2 answers
Having clause in sql
SQL
0 vote212 views1 answer
Mysql earlier than date
SQL
0 vote250 views1 answer
Postgres populate table from another table
SQL
0 vote227 views1 answer
Sql database size
SQL
8 votes245 views4 answers
How to calculate the age from date of birth in python
SQL
3 votes223 views1 answer
Delete all content in table mysql
SQL
6 votes201 views2 answers
Spring data jpa application.properties mysql
SQL
2 votes235 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote243 views1 answer
Top frequency in sql server
SQL
0 vote233 views1 answer
Grouping by email domain mysql
SQL