ACCEPT zipcode PROMPT 'Please enter a zip code to see branch phone numbers: ';

SELECT RPAD(Name, 30) As "BranchName",
RPAD(PhoneNumber, 12) As "PhoneNumber"
FROM Branch, B_bpn, BranchPhoneNumber
WHERE Branch.ID = BranchID
      AND PhoneNumberID = BranchPhoneNumber.ID
      AND Zip = '&zipcode';
