Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

10th Edition

0137916787, 978-0137916788

More Books

Students also viewed these Databases questions