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 vote120 views1 answer
T-SQL Create Trigger
SQL
0 vote115 views2 answers
Import .sql into postgres db command
SQL
0 vote127 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote109 views1 answer
Oracle string length
SQL
0 vote152 views1 answer
T-sql delete view if exists
SQL
0 vote169 views1 answer
Import sql dump into postgresql database
SQL
18 votes110 views6 answers
Drop table if exists
SQL
0 vote117 views1 answer
Tsql table column constraint must be uppercase
SQL
1 vote117 views1 answer
Mysql add fields
SQL
1 vote114 views1 answer
Insert column after column mysql
SQL