Computers and Technology, 20.05.2021 21:40 jenniferalvarez360

From the data tables, determine the location having the most companies. List the names of the employees who work in that location and the names of their companies. The output should consists of two columns: People, Name Companies. Name. The rows may be in any order. Schema
There are 3 tables: PEOPLE, COMPANIES, LOCATIONS.
PEOPLE
Name Type Description
ID STRING Unique ID of the person.
NAME STRING NAME of the person
COMPANY_ID STRING ID of the company that person works for
COMPANIES
Name Type Description
ID STRING Unique ID of the company
NAME STRING NAME of the company
LOCATION_ID STRING ID of the location of the company
LOCATIONS
Name Туре Description
ID STRING Unique ID of the location
NAME STRING Name of the location
Sample Data Tables
PEOPLE
ID NAME COMPANY_ID
a3c7f250f72e452fa5030d587f14922b Chris 0734a7703d1d4dab8f87be8396415452 71a1e133e7ca4f128f43eed1f5a3a8bc Sam 55865e7b74ef46a389a1edb9de030b9c 5a439620490646158bc6dd548ddeab21 Faker 2268c402cdfd48c4a7ee8d3a88c162e0
COMPANIES
ID NAME LOCATION_ID
0734a7703d1d4dab8f87be8396415452 Wright-Phillips e2ec9af444ff4e1aaa0b2f4aa19e7063 55865e7b74ef46a389a1edb9de030b9c HazardEden e2ec9af444ff4e 1 aaa0b2f4aa19e7063 2268c402cdfd48c4a7ee8d3a88c162e0 Palmieri 2268c402cdfd48c4a7ee8d3a88c162e0
LOCATIONS
ID NAME
e2ec9af444ff4e1aaa0b2f4aa 19e7063 Wrightmouth
b927735edd1d4354a0a45d8c22e45a53 New Joseph
Sample Output
Chris Wright-Phillips
Sam Hazard Eden
Explanation
Wrightmouth is the location with the most companies. Chris and Sam work there at the companies listed.

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 05:30

Gerard is currently working as an entry-level customer support technician, but he would like to someday become a software developer. what is the best first step to understand what he should do? ask his manager for a new job or at least a job recommendation study graphic design in order to obtain the necessary skills use career resources to investigate what skills and education are required work part-time as an entry-level web developer question 13 (true/false worth 6 points) (08.03 lc) career resources are used to explore career options and find career information. true false question 14(multiple choice worth 6 points) (08.01 mc) classify the following skills: writing html code, evaluating color theory, using design principles. hard skills interpersonal skills people skills soft skills question 15 (true/false worth 6 points) (08.03 lc) a mentor is a person who is advised, trained, or counseled by a trusted mentee. true false

Answers: 2

Answer

Computers and Technology, 23.06.2019 06:20

Which text function capitalizes the first letter in a string of text? question 10 options: upper capital first proper

Answers: 1

Answer

Computers and Technology, 23.06.2019 16:30

You have read about the beginnings of the internet and how it was created. what was the internet originally created to do? (select all that apply) share research. play games. communicate. share documents. sell toys

Answers: 1

Answer

Computers and Technology, 23.06.2019 22:20

Learning sign language is an example of a(n) learning sign language is an example of a(n)

Answers: 2

Answer

You know the right answer?

From the data tables, determine the location having the most companies. List the names of the employ...

Questions