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 vote282 views1 answer
Oracle job session
SQL
0 vote260 views1 answer
Sql gap missing values
SQL
0 vote258 views1 answer
Get duplicate entry sql
SQL
5 votes307 views4 answers
Traduction
SQL
9 votes285 views4 answers
Oracle get table column names
SQL
0 vote279 views1 answer
Selecting Data in SQL - Select Data
SQL
9 votes293 views6 answers
Check constraint in sql
SQL
3 votes282 views2 answers
Sql select data from last week
SQL
1 vote278 views2 answers
Mysql error 1215
SQL
4 votes261 views2 answers
Tables in sql
SQL