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

1 vote197 views1 answer
Rermove categories woocommerce sql
SQL
0 vote201 views1 answer
Python mysql query to dataframe
SQL
26 votes201 views2 answers
Mysql workbench download
SQL
1 vote186 views1 answer
Show table columns
SQL
7 votes194 views2 answers
What is sql clause
SQL
16 votes218 views3 answers
Get count of duplicate records
SQL
4 votes234 views1 answer
Rename stored procedure in sql server
SQL
0 vote180 views1 answer
Sqlite3 now
SQL
0 vote199 views1 answer
Delete record by id sql
SQL
0 vote176 views1 answer
SQL division of an integer by another integer get float CAST
SQL