Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as SQL by Trii ( 16 years ago )
SELECT sum(s.sent) AS sent
, sum(s.response) AS response
FROM (SELECT CASE WHEN type = 1 THEN 1 END AS sent
, CASE WHEN type = 4 THEN 1 END AS response
FROM table
WHERE some condition) as s;
Revise this Paste
Children: 21634