IDNLearn.com: Where your questions meet expert advice and community support. Get accurate and comprehensive answers from our network of experienced professionals.
MYSQL Workbench question
Using a function, display the customer who has the highest credit limit.
. Display the customer number, customer name and credit limit.
I need my answer checked over for the question.
#Show me a list of customers who have the highest credit limit
use premier_products;
select count(*) customer_num, customer_name, credit_limit
from customers
Where credit_limit=
(Select AVG (credit_limit)
from customers)
Sagot :
We appreciate your contributions to this forum. Don't forget to check back for the latest answers. Keep asking, answering, and sharing useful information. Your questions find answers at IDNLearn.com. Thanks for visiting, and come back for more accurate and reliable solutions.