Aggregation function in Objection.js

Question

How I can write query with Objection.js?

SELECT AVG(field), COUNT(*) FROM tab

Please help me

Answer 1

Try this:

const result = await Tab.query().avg(`field`).count(`*`)
console.log(result[0].avg, result[0].count)