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 vote114 views1 answer
Gcloud check sql
SQL
0 vote116 views1 answer
Python sql last insertend
SQL
9 votes125 views2 answers
Convert data type in sql
SQL
2 votes78 views1 answer
Foreign key example in dbms
SQL
32 votes127 views6 answers
How to change column name in sql
SQL
11 votes119 views1 answer
Ddl materialized view
SQL
2 votes112 views1 answer
Oracle sql drop column if exists
SQL
1 vote135 views2 answers
One to one and one to many relationship
SQL
0 vote131 views1 answer
Update sqlite
SQL
1 vote107 views1 answer
Oracle lock user
SQL