Simple Queries

1. For example, to find all customers having an account at the SFU branch:

   

   • A P. before the variable causes printing.
   • A P.ALL. prefix suppresses duplicate elimination.
   • A P. in front of the row prints all attributes.
   • The domain variable may be omitted if it is not used elsewhere.
   • Arithmetic expressions are allowed.
   • Comparison operators are allowed, space on left hand side is left blank.
2. To find the names of all branches not located in Burnaby:

   

3. To find all customers having an account at both the SFU and the MetroTown branch:

   

4. To find all customers having an account at either branch or both:

   

5. Find all customers having an account at the same branch as Jones: