1)
SELECT
    `CUST_NAME`
FROM
    `customer`
WHERE
    CUST_NAME LIKE "Ms%";



2)
SELECT
    COUNT(`CUST_NAME`)
FROM
`customer`
WHERE
    CUST_NAME LIKE "Ms%";




4)
UPDATE `customer`
SET GRADE = 10
WHERE
`CUST_COUNTRY` = "georgia";




5)
SELECT
    DISTINCT `AGENT_CODE`
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(
    70,"VAXTANGI","ALABAMA","UGANDA","TBILISI",11,120000,111111,11111123,700,"558193231",99
);



7)

SELECT
    AVG(PAYMENT_AMT)
FROM
 `customer`
 GROUP BY
    CUST_COUNTRY;

8)

SELECT
    AVG(PAYMENT_AMT)
FROM
 `customer`
 GROUP BY
  CUST_CITY;



9)
SELECT
    SUM(PAYMENT_AMT)
FROM
    `customer`;


10)
SELECT
CUST_COUNTRY,
SUM(PAYMENT_AMT) AS JAMI
FROM `customer`
GROUP BY
CUST_COUNTRY
ORDER BY
JAMI DESC;

11)
SELECT
    PAYMENT_AMT
FROM
    `customer`
ORDER BY
    PAYMENT_AMT
DESC
LIMIT 0, 10


12)SELECT
    PAYMENT_AMT
FROM
    `customer`
ORDER BY
    PAYMENT_AMT
ASC
LIMIT 0, 10