The SUM() function in SQL returns the total sum of a numeric column. It's commonly used to calculate totals in datasets like sales, quantities, or prices.

Trying to select using the SUM function creates a SQL query with the backticks in the wrong position. The query I'm using is: const results = await orm.em .createQueryBuilder(User, "u") .select(["u.id ...