Answered

Discover answers to your questions with Westonci.ca, the leading Q&A platform that connects you with knowledgeable experts. Get immediate and reliable solutions to your questions from a community of experienced experts on our Q&A platform. Discover in-depth answers to your questions from a wide network of professionals on our user-friendly Q&A 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 :

Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. We appreciate your time. Please revisit us for more reliable answers to any questions you may have. Westonci.ca is here to provide the answers you seek. Return often for more expert solutions.