5.  SELECT DISTINCT AGENT_CODE FROM `agents`

1. SELECT * FROM `customer`WHERE CUST_NAME LIKE 'Ms.'

4. UPDATE `customer` SET `GRADE`= 10 WHERE CUST_COUNTRY = 'Georgia'

9. SELECT AVG(PAYMENT_AMT) FROM customer

6.
INSERT INTO `customer` (`CUST_CODE`, `CUST_NAME`, `CUST_CITY`, `WORKING_AREA`, `CUST_COUNTRY`, `GRADE`, `OPENING_AMT`, `RECEIVE_AMT`, `PAYMENT_AMT`, `OUTSTANDING_AMT`, `PHONE_NO`, `AGENT_CODE` VALUES

('3', "Ms", "Georgia", "West Mason, Norway", '6', '7315.00', '460194.00', '4667.00', '9858.00', '087.655.695', '12')






INSERT INTO `customer` (`CUST_CODE`, `CUST_NAME`, `CUST_CITY`, `WORKING_AREA`, `CUST_COUNTRY`, `GRADE`, `OPENING_AMT`, `RECEIVE_AMT`, `PAYMENT_AMT`, `OUTSTANDING_AMT`, `PHONE_NO`, `AGENT_CODE` VALUES

('4', "Dr", "Georgia", "West Mason, Norway", '5', '7345.00', '460184.00', '4669.00', '9854.00', '087.655.677', '2')

7. SELECT CUST_COUNTRY,  AVG(PAYMENT_AMT) FROM customer GROUP BY CUST_COUNTRY
8. SELECT CUST_CITY,  AVG(PAYMENT_AMT) FROM customer GROUP BY CUST_CITY




11 . SELECT * FROM customer ORDER BY PAYMENT_AMT DESC LIMIT 10

12. SELECT * FROM customer ORDER BY PAYMENT_AMT ASC LIMIT 10

10. SELECT CUST_COUNTRY, SUM(PAYMENT_AMT) FROM customer GROUP BY CUST_COUNTRY