Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Window functions

Location matters

Report a typo

Look at the incomplete query below. What should you change, if you want to sort the results by baby_age?

SELECT
 gender,
 baby_age,
 AVG(baby_height) OVER(PARTITION BY gender ORDER BY baby_age) AS avg_height 
FROM babies;

Select one option from the list

Nothing, because there is ORDER BY baby_age in the query

Add babe_age before SELECT

Add ORDER BY baby_age at the end of the query

Add age before SELECT

___

Create a free account to access the full topic