Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following MySQL tables and their respective fields. Customers table cust_id, cust_name, credit_limit, age, email Orders table order_id, cust_id, product, quantity, price Find the
Consider the following MySQL tables and their respective fields. Customers table cust_id, cust_name, credit_limit, age, email Orders table order_id, cust_id, product, quantity, price Find the ids of all the customers with order quantity higher than 700 or credit limit greater than or equal t Answer Options Select any one option Select distinct Customers.cust_id from Orders Right JOIN Customers ON Customers.cust_id= Orders.cust_id where (Customers.credit_limit >=500 OR Orders.quantity >=700 ) Select distinct Customers.custid from Customers LEFT JoIN Order's ON Customers.cust_id=Orders.cust_id
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started