Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Aggregate functions

Street lengths

Report a typo

Write a query to compute minimum, average and maximum street lengths in the table streets.

street_name bus_stops crossings is_one_way length
Brickstone 2 0 no 3
Red Woods 4 5 no 10
Water Sports Arena 1 0 yes 3
Sun Valley 10 10 no 15
River Shore 3 3 yes 8
Write an SQL statement





___

Create a free account to access the full topic