Finish this for brainliest and 30 points

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

Step2247 [10]

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

6 0

2 years ago

The goal of this project is to become familiar with basic Python data processing and file usage. By the end of this project, stu

xenn [34]

Answer:

Explanation:

The question does not provide any actual data to manipulate or use as input/guidline therefore I have taken the liberty of creating a function for each of the question's points that does what is requested. Each of the functions takes in a list of the needed data such as a list of field test averages for part 1, or a list of field tests for part 2, etc. Finally, returning the requested output back to the user.

import matplotlib.pyplot as plt

from collections import Counter

def best_pilot(field_test_average):

return max(field_test_average)

def find_average(field_test):

average = sum(field_test) / len(field_test)

return average

def create_histogram(field_test_colors):

count_unique_elements = Counter(field_test_colors).keys()

plt.hist(field_test_colors, bins=len(count_unique_elements))

plt.show()

def average_name_lengths(first, last):

first_name_sum = 0

last_name_sum = 0

count = 0

for name in first:

first_name_sum += len(name)

count += 1

for name in last:

last_name_sum += len(name)

first_name_average = first_name_sum / count

last_name_average = last_name_sum / count

return first_name_average, last_name_average

7 0

2 years ago

Write a program to display MPH (Miles per Hour). Create a function to calculate the MPH. Ask the user for the number of miles dr

puteri [66]

Answer:

In Python:

def MPH(miles,minutes):

mph = round(60 * miles/minutes,1)

return mph

miles = float(input("Miles: "))

minutes = float(input("Minutes: "))

if miles>0 and minutes>0:

print("MPH: ",MPH(miles,minutes))

else:

print("Positive inputs only")

Explanation:

This defines the function

def MPH(miles,minutes):

This calculates mph rounded to 1 decimal place

mph = round(60 * miles/minutes,1)

This returns the calculated mph

return mph

The main begins here

This gets input for miles

miles = float(input("Miles: "))

This gets input for minutes

minutes = float(input("Minutes: "))

If miles and minutes are positive

if miles>0 and minutes>0:

This calls the MPH function

print("MPH: ",MPH(miles,minutes))

If otherwise, this prompts the user for positive inputs

<em> print("Positive inputs only")</em>

7 0

3 years ago

There are 22 gloves in a drawer: 5 pairs of red gloves, 4 pairs of yellow, and 2 pairs of green. You select the gloves in the da

AVprozaik [17]

Answer:

Best-case = 2 gloves

Worst-case = 12 gloves

Explanation:

For the best-case: Because there is a chance that you take two gloves of the same color in the first two round the answer is two.
For the worst-case: The worst case would be if, for each color-group of gloves you take the right or left glove, for example, you take 5 left-hand red gloves then 4 left-hand yellow gloves, then 2 left-hand green gloves, because you have already taken all of the left gloves the next one is going to be a right glove that is going to pair with one of the already selected gloves, therefore, the answer is 12 -> 5+4+2+1 = 12

3 0

3 years ago

All of the following changes have created an urgent need for centralization except: Select one: a. The Internet boom inspired bu

kifflom [539]

All of the following changes have created an urgent need for centralization except The number of qualified software programmers and PC repair technicians is dwindling

<h3><u>Explanation:</u></h3>

When the processing tasks are carried out on a centralized server it refers to the Centralization. In this type of architecture all the computer systems will be connected to a single server in which all the computational work are performed. The client machines that are connected to the central server will get the resources for computing from the centralized server.

The main reasons for the purpose of centralization includes the following such as the development in the internet that required many computer networks, the basic functioning of the business in which the needed applications are fed on the intranets, the cost associated in the maintenance of personal computers on the single network.

3 0

3 years ago