10 lines
389 B
Plaintext
10 lines
389 B
Plaintext
SELECT
|
|
category.name,
|
|
SUM(transaction.amount) AS total
|
|
FROM "main"."transaction" as transaction
|
|
JOIN "main"."transactioncategory" as category ON transaction.subcategory = category.primary_key
|
|
WHERE transaction.user = 'faab09bcdcc44038907d054ca990a7f4'
|
|
AND transaction.transaction_date >= '2022-10-01'
|
|
AND transaction.transaction_date < '2022-11-01'
|
|
GROUP BY category.name;
|