要创建一个报表，这个报表将显示那些信用限额大于所有客户平均信用限额的客户，应使用如下的哪个查询语句
A．SELECT
last_name, first_name
FROM
customer
WHERE
credit_limit＞AVG(credit_limit);
B．SELECT
last_name, first_name, AVG(credit_limit)
FROM
customer
GROUP BY AVG(credit_limit);
C．SELECT
last_name, firs_name, AVG(credit_limit)
FROM
customer
GROUP BY AVG(credit_limit)
HAVING
credit_limit＞AVG(credit_limit);
D．SELECT
last_name, first_name
FROM
customer
WHERE
credit_limit＞(SELECT AVG(credit_limit)
FROM
customer);
E．SELECT
last_name, first_name
FROM
customer
WHERE
credit_limit=(SELECT AVG(credit_limit)
FROM
customer);
