database sql 3

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