Answered

Welcome to Westonci.ca, where you can find answers to all your questions from a community of experienced professionals. Get the answers you need quickly and accurately from a dedicated community of experts on our Q&A platform. Get immediate and reliable solutions to your questions from a community of experienced professionals on our platform.

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 time on our site. Don't hesitate to return whenever you have more questions or need further clarification. We hope this was helpful. Please come back whenever you need more information or answers to your queries. Get the answers you need at Westonci.ca. Stay informed by returning for our latest expert advice.