ACCEPT bname PROMPT 'Please enter part of the branch name: ';

SELECT RPAD(Name, 30) As "BranchName",
RPAD(COUNT(Vehicle.ID), 12) As "VehicleCount"
FROM Branch, B_v, Vehicle
WHERE Branch.ID = BranchID
      AND VehID = Vehicle.ID
GROUP BY Name
HAVING LOWER(Name) LIKE '%&bname%'; 
