Task: Text to Code
Input (English): find each value of bedType in Rooms table along with the average maxOccupancy of the corresponding rows to each value
Output (English): SELECT bedType , Avg ( maxOccupancy ) FROM Rooms GROUP BY bedType