SELECT user_id,
SUM(CASE WHEN status='credit' THEN amount ELSE 0 END) credit,
SUM(CASE WHEN status='deposit' THEN amount ELSE 0 END) deposit
FROM src_table
GROUP BY user_id
CLICK HERE to find out more related problems solutions.
SELECT user_id,
SUM(CASE WHEN status='credit' THEN amount ELSE 0 END) credit,
SUM(CASE WHEN status='deposit' THEN amount ELSE 0 END) deposit
FROM src_table
GROUP BY user_id
CLICK HERE to find out more related problems solutions.