Sollicitatievraag bij Gore Mutual

Can you explain what GROUP BY does in SQL? What is overfitting?