How to Get the Average Height of People in a Table

P apply to Apache iceberg or metadata files to give you sort of like one use case. What a window function is. It doesn't return you each row of the table. It returns you, um, the calculation based on a different value. Sometimes though I might want a data from individual records along with that sort of aggregated or, uh, more high level look.