IDNLearn.com: Your go-to resource for finding expert answers. Get prompt and accurate answers to your questions from our experts who are always ready to help.
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 presence in our community is highly appreciated. Keep sharing your insights and solutions. Together, we can build a rich and valuable knowledge resource for everyone. Your questions deserve reliable answers. Thanks for visiting IDNLearn.com, and see you again soon for more helpful information.
