Find the name of route that has the lowest number of deliveries?
select t1.route_name from delivery_routes as t1 join delivery_route_locations as t2 on t1.route_id = t2.route_id group by t1.route_id order by count ( * ) desc limit 1
How many route names in this table?
select count ( route_name ) from delivery_routes
How many delivery route location in this table?
select t2.location_code,count ( * ) from delivery_routes as t1 join delivery_route_locations as t2 on t1.route_id = t2.route_id