sql group by one column from multiple tables code example

Example: how to select two columns from table with group by one sql server

SELECT Name, Size, AVG( UnitPrice )
   FROM Products
   GROUP BY Name, Size;