SELECT Concat(U.roadmark, ' ', U.number) AS Unit, COUNT(*) AS RecCnt FROM units U WHERE (U.roadmark = 'via') AND ((U.number >= 6400) AND (U.number <= 6499)) GROUP BY Unit ORDER BY UnitUnit Count VIA 6400 9
VIA 6401 16
VIA 6402 8
VIA 6403 20
VIA 6404 20
VIA 6405 16
VIA 6406 21
VIA 6407 16
VIA 6408 17
VIA 6409 21
VIA 6410 25
VIA 6411 20
VIA 6412 20
VIA 6413 12
VIA 6414 17
VIA 6415 26
VIA 6416 19
VIA 6417 12
VIA 6418 16
VIA 6419 12
VIA 6420 29
VIA 6421 21
VIA 6422 2
VIA 6424 18
VIA 6425 7
VIA 6426 19
VIA 6427 17
VIA 6428 17
VIA 6429 12
VIA 6431 22
VIA 6432 21
VIA 6433 10
VIA 6434 14
VIA 6435 10
VIA 6436 12
VIA 6437 11
VIA 6438 14
VIA 6439 12
VIA 6440 14
VIA 6441 10
VIA 6442 17
VIA 6443 9
VIA 6444 1
VIA 6445 8
VIA 6446 17
VIA 6448 6
VIA 6449 11
VIA 6451 11
VIA 6452 16
VIA 6453 14
VIA 6454 8
VIA 6455 11
VIA 6456 27
VIA 6457 7
VIA 6458 29
VIA 6459 8
Add a sighting