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 vote160 views1 answer
Fetching data from mysqldb
SQL
10 votes131 views5 answers
Between keyword in sql
SQL
0 vote172 views1 answer
Sql server datetime
SQL
4 votes138 views1 answer
W3schools create table
SQL
0 vote150 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote134 views2 answers
Dbms interview questions
SQL
0 vote142 views1 answer
Query archive mode
SQL
0 vote131 views3 answers
Between keyword sql
SQL
0 vote132 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
-1 vote136 views1 answer
Su: Authentication failure mysql
SQL