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

2 votes339 views2 answers
How to create an empty table from an existing table
SQL
0 vote320 views1 answer
Sum values by month mariadb
SQL
0 vote325 views1 answer
Liquibase update row
SQL
5 votes348 views1 answer
Sql add column after another
SQL
0 vote368 views1 answer
Bigrock database connection string
SQL
34 votes322 views6 answers
Sql change data type
SQL
0 vote340 views1 answer
Excel vba import data to sql server
SQL
0 vote303 views1 answer
How to insert same table data using mysql query
SQL
0 vote328 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote319 views1 answer
Check duplicate values plsql
SQL