Computers and Technology

For the location with the most companies, list the names of the people and the companies they work for. The output should consist of two columns: PEOPLE. NAME COMPANIES. NAME 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
IID 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.

answer
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 23:50, Crull5999
List a few alternative options and input and output over the standerd keyboard and monitor. explain their functioning in details.
Answers: 2
image
Computers and Technology, 23.06.2019 01:40, hanjonez
Writing a modular program in visual c++. i am new to this and not sure what i am missing. i am getting the following error: baddate. cpp: in function ‘int main()’: baddate. cpp: 50: 3: error: ‘else’ without a previous ‘if’elsehere are the instructions and code: writing a modular program in c++in this lab, you add the input and output statements to a partially completed c++ program. when completed, the user should be able to enter a year, a month, and a day. the program then determines if the date is valid. valid years are those that are greater than 0, valid months include the values 1 through 12, and valid days include the values 1 through 31.notice that variables have been declared for you. write the simulated housekeeping() function that contains the prompts and input statements to retrieve a year, a month, and a day from the user. include the output statements in the simulated endofjob() function. the format of the output is as follows: month/day/year is a valid date. ormonth/day/year is an invalid date. execute the program entering the following date: month = 5, day = 32, year = 2014. record the output of this program. execute the program entering the following date: month = 9, day = 21, year = 2002. record the output of this /* program name: baddate. cppfunction: this program determines if a date entered by the user is valid. input: interactiveoutput: valid date is printed or user is alerted that an invalid date was entered*/#include bool validatedate(int, int, int); using namespace std; int main(){// declare variablesint year; int month; int day; const int min_year = 0, min_month = 1, max_month = 12, min_day = 1, max_day = 31; bool validdate = true; // this is the work of the housekeeping() method// get the year, then the month, then the daycout< < "enter the year"< > year; cout< < "enter the month"< > month; cout< < "enter the day"< > day; // this is the work of the detailloop() method// check to be sure date is validif(year < = min_year) // invalid yearvaliddate = false; else if (month < min_month || month > max_month) // invalid monthvaliddate = false; else if (day < min_day || day > max_day) // invalid dayvaliddate = false; // this is the work of the endofjob() method// test to see if date is valid and output date and whether it is valid or notif(validdate == true); {// output statementcout<
Answers: 1
image
Computers and Technology, 23.06.2019 02:30, reyne36
Rafael needs to add a title row to a table that he has inserted in word. what should he do? use the alignment options. use the merge and center option for all the cells in the top row. use the merge and center option on the first two cells in the top row. none of the above
Answers: 3
image
Computers and Technology, 23.06.2019 18:40, brooklyn4932
How does is make you feel when you're kind to others? what are some opportunities in your life to be more kind to your friends and loved ones? imagine a world where kindness has be outlawed. how would people act differently? would your day-to-day life change significantly? why or why not?
Answers: 2
Do you know the correct answer?
For the location with the most companies, list the names of the people and the companies they work f...

Questions in other subjects:

Konu
English, 12.11.2020 02:20
Konu
Mathematics, 12.11.2020 02:20