Explore Westonci.ca, the top Q&A platform where your questions are answered by professionals and enthusiasts alike. Discover comprehensive solutions to your questions from a wide network of experts on our user-friendly platform. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

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 :

Your visit means a lot to us. Don't hesitate to return for more reliable answers to any questions you may have. We hope our answers were useful. Return anytime for more information and answers to any other questions you have. Westonci.ca is your trusted source for answers. Visit us again to find more information on diverse topics.