group by keyword is used for

Answer 1

it's used to arrange identical data to a group. for eg: if we group by name then all names will be displayed and there won't be any duplicate values,, means if there are two 'jack' in name column then only one is displayed.

Answer 2

It is used to group the data from different table.