i have a tabe of accounting transaction (billnumber ,date,sum). i need to get result of every bill his total (bill number, total).
i found the way .the documantation wasnt clear to me
const lines = await database.select(‘bill’)
.sum(‘bruto as b’)
it add field name ‘b’ for interpulation