Check out example codes for "sql how to use group by". It will help you in understanding the concepts better.

Code Example 1

SELECT column1, function_name(column2)
FROM table_name
WHERE condition
GROUP BY column1, column2
ORDER BY column1, column2;

function_name: Name of the function used for example, SUM() , AVG().
table_name: Name of the table.
condition: Condition used.

Learn ReactJs, React Native from akashmittal.com