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 vote152 views2 answers
Null value in column violates not-null constraint
SQL
0 vote97 views1 answer
How to see the content of tables in pgadmin
SQL
10 votes112 views2 answers
Sql where clause multiple values
SQL
0 vote147 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
1 vote138 views1 answer
Wherein mysql
SQL
15 votes185 views6 answers
Drop foreign key mysql
SQL
17 votes158 views3 answers
Postgresql list users
SQL
0 vote186 views1 answer
Insert into table with only identity column
SQL
1 vote137 views1 answer
How to see logical reads in sql server
SQL
0 vote147 views1 answer
Drop all triggers oracle
SQL