In this context,
ABS(x): Returns the absolute value of the input value 'x'. For example, ABS(-10) would return 10.
ROUND(x, d): Rounds the input ...
For further actions, you may consider blocking this person and/or reporting abuse
If you need to include more information than just the grouped filed and aggregate you can also use the OVER() syntax.
SELECT category, SQRT(SUM(sales)) AS square_root_salesFROM products
GROUP BY category;
becomes
SELECT category, ProductName, SQRT(SUM(sales) OVER (PARTITION BY category)) AS square_root_sales_of_categoryFROM products;
This will aggregate the sales by category and display the result for the product category against the product row,
Thanks for the information Reese.
All SQL math functions list : postgresql.org/docs/9.5/functions-...
Don't forget to share your valuable comments!