Connect with knowledgeable individuals and find the best answers at IDNLearn.com. Ask anything and receive thorough, reliable answers from our community 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 :
Thank you for using this platform to share and learn. Keep asking and answering. We appreciate every contribution you make. Your questions deserve accurate answers. Thank you for visiting IDNLearn.com, and see you again for more solutions.