Jarway $2024$ Fins Eraninstas

Write SQL queries to answer the following questions. Use the information glven in each

table.

CUSTOMER

a$)$ List the customer details who has a balanos of m$$re than $300.$

b$)$ List the customer's name, area code, and inwcice number of all customers. Sort the

answer in descending order by customer name.

$(4$ Marks$)$

c$)$ List the male customer details whose name starts with the letter $\text{'}O\text{'}.$

$(4$ Marks$)$

d$)$ Find the number of male customers and display the column name as

Total$\_$Male$\_$Customer'.

$(4$ Marks$)$

u$)$ Find the minimum, maximum, averogo, and number of sustemers for sach arsa code.

$(4$ Marks$)$

f$)$ Change the balance for Siti to $500.$

$(4$ Marks$)$

g$)$ Find the name of a customer who fives in the same area as Diana.

$(4$ Marks$)$

$[$Total: $28$ Marks$]$