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
counting delivery route location refers to COUNT(*); joining tables refers to the use of JOIN on matching columns;