多选题 要创建一个报表，这个报表将显示那些信用限额大于所有客户平均信用限额的客户，应使用如下的哪个查询语句?
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);