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

9 votes205 views3 answers
Date format in sql
SQL
14 votes178 views3 answers
Trim sql
SQL
2 votes191 views1 answer
Drop all foreign key constraints mysql
SQL
10 votes205 views4 answers
Join multiple tables in sql
SQL
24 votes208 views4 answers
Delete db postgres
SQL
1 vote204 views1 answer
Oracle user last connection date
SQL
6 votes272 views3 answers
Psql show columns of table
SQL
0 vote131 views1 answer
Calculate discount from original price sql
SQL
0 vote180 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
0 vote183 views1 answer
Oracle date winter time
SQL