Connect with a knowledgeable community and get your questions answered on IDNLearn.com. Get the information you need from our community of experts, who provide detailed and trustworthy answers.
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 participation means a lot to us. Keep sharing information and solutions. This community grows thanks to the amazing contributions from members like you. IDNLearn.com provides the best answers to your questions. Thank you for visiting, and come back soon for more helpful information.
