Kim is writing a sql query that will pull a list of customers with outstanding orders and the sales rep for each order. What sho

Question

rewona [7]

2 years ago

11

Kim is writing a sql query that will pull a list of customers with outstanding orders and the sales rep for each order. What sho

uld the where phrase say in her query?.

Computers and Technology

1 answer:

Step2247 [10] · Answer 1 · 2022-12-23T09:32:32+03:00

What the phrase should say in Kim's SQL Query is; WHERE Customer = Sales Rep

<h3>What is SQL Query?</h3>

Structured Query Language (SQL) is defined as a standardized programming language that is used to manage relational databases and perform various operations on the data in them.

Now in SQL Query, when one SQL query is embedded in another SQL query to simulate a join, the second SQL query is embedded in the "WHERE" of the first query.

Since the query will pull a list of customers with outstanding orders and the sales rep for each order. Then, the where phrase will be;

WHERE Customer = Sales Rep

Read more about SQL Query at; brainly.com/question/10097523