JUST Q2 NEEDED

Quiz 2 CLO 4 Marks 10 Consider the following customer table and write SQL queries. (Queries should be hand written on paper) Customer CustNo CustFirstName CustLastName CustStreet CustCity CustState CustZip CustBal 1. List the customer number, the name (first and last), the city, and the balance of customers who reside in Denver with a balance greater than $ 150 or who reside in Seattle with a balance greater than $300. 2. List the average balance of customers by city. Include only customers residing in Washington State (WA). 3. List the average balance and number of customers by city. Only include customers residing in Washington State (WA). Eliminate cities in the result with less than two customers. 4. Increase the balance of customers by 10 percent whose name containing the word 'Ali'in first name 5. Delete the rows from customer tables for those customers who reside in Seattle with a balance greater than $300