Query 1: Find the names of customers who live in cities with names ending in “on”.
customer_name customer_city
Hayes Harrison
Jones Harrison
Williams Princeton
Query 2: Find the names and cities of customers who have account(s) at “Downtown” branch.
customer_name customer_city
Hayes Harrison
Johnson Palo Alto
Query 3: Print in descending order the names of customer who have a loan amount between 1000 and 2000.
customer_name amount
Williams 1000.00
Smith 2000.00
Jones 1000.00
Jackson 1500.00
Hayes 1500.00
Adams 1300.00
Query 4: Find all customers who have a loan, an account, or both.
customer_name
Hayes
Johnson
Jones
Lindsay
Majeris
Smith
Turner
Adams
Curry
Jackson
McBride
Williams
Need help with this assignment or a similar one? Place your order and leave the rest to our experts!