Use multiple where clauses to retrieve different data

In SQL, you can use the where clause to filter a specific row to customize the method of retrieved data from the table. This problem proposes the challenge to extract two different datasets from the same table, and each data set meets different where clauses.

The sample table "TransaCTIONS" stores the records of financial transactions, which are characterized by its ID, account ID, budget ID, points and transaction types obtained. The task is to calculate the sum of the distribution accumulation of each unique budget ID and the sum of the distribution points.

For this, it can construct a single SQL query, which combines the necessary WHERE clauses. The following query achieves the result of the required:

select budget_id, SUM (Case When Type = 'Allocation' THEN POINTS ELSE 0 END) as allocated, SUM (Case When Type = 'Issue' THEN POINTS ELSE 0 END) As ISSUED From transactions Group by budget_id

SELECT budget_id, 
       SUM(CASE WHEN type = 'allocation' THEN points ELSE 0 END) AS allocated,
       SUM(CASE WHEN type = 'issue' THEN points ELSE 0 END) AS issued
FROM transactions
GROUP BY budget_id