whtsky's wiki

1970-01-01 query "收支明细" "
SELECT
  year, month, account, sum(number) as Total, currency, payee, narration
FROM
    year >= 2011
WHERE
    account ~ 'Expenses' OR
    account ~ 'Income'
GROUP BY year, month, account, currency, payee, narration
ORDER BY year, month, currency, Account DESC
FLATTEN
"

1970-01-01 query "每月收支" "
SELECT
  year, month, root(account, 1) as account, sum(number) as Total, currency
FROM
    year >= 2011
WHERE
    account ~ 'Expenses' OR
    account ~ 'Income'
GROUP BY year, month, account, currency
ORDER BY year, month, account DESC
FLATTEN
"

在 Fava 的侧边栏里可以看到定义好的 Query 。