Question

Consider the Goldstar database and the query below. What will the query display? SELECT city, COUNT(performance)...

Consider the Goldstar database and the query below. What will the query display? SELECT city, COUNT(performance) AS TotalEmployees FROM location, employee WHERE location.location_id = employee.location_id GROUP BY city; ?

The total number of employees in each city that have NOT received performance ratings

The total number of employees in each city

The total number of employees in each city that have received performance ratings

None of the other answers provided is correct

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

The query output will be:

The total number of employees in each city that have received performance ratings

Explanation

  • The select statement (SELECT city, COUNT(performance) AS TotalEmployees ) is selecting two things - the city and the count of the number of employees who received a performance rating
  • The database selected contains the tables location, employee
  • WHERE location.location_id = employee.location_id is basically identifying the location from the different tables. The key, in this case, is the location id which is the matching parameter, the link between the two tables.
  • Grouping is by city.

Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Consider the Goldstar database. Choose the query that will display all of the position titles and...
Consider the Goldstar database. Choose the query that will display all of the position titles and the number of employees that hold that position. SELECT title, COUNT(ssn) AS TotalEmployees FROM position, employee WHERE position.location_id = employee.position_id GROUP BY title; SELECT title, SUM(ssn) AS TotalEmployees FROM position, employee WHERE position.position_id = employee.position_id GROUP BY title; SELECT title, COUNT(ssn) AS TotalEmployees FROM position, employee WHERE position.position_id = employee.position_id GROUP BY title; SELECT title, SUM(ssn) AS TotalEmployees FROM position, employee WHERE position.location_id =...
Consider the Goldstar database. Choose the query that displays the average salary for all positions in...
Consider the Goldstar database. Choose the query that displays the average salary for all positions in the city of Chicago. SELECT title, AVG(max_salary) AS AverageSalary FROM position, employee, location WHERE location.location_id = employee.location_id AND position.position_id = employee.position_id AND city = "Chicago" GROUP BY title; SELECT title, AVG(salary) AS AverageSalary FROM position, employee, location WHERE position.position_id = employee.position_id AND location.location_id = employee.location_id AND city = "Chicago" GROUP BY title; SELECT title, AVG(salary) AS AverageSalary FROM position, employee, location WHERE location.location_id =...
Using the Company database in Oracle, construct SQL queries for the following (note: I will make...
Using the Company database in Oracle, construct SQL queries for the following (note: I will make the files to create and populate the Company database available on Isadore shortly): List the last name and address of managers who have a dependent with the same first name as themselves. Retrieve the names of all employees who are directly supervised by ‘Franklin Wong’. Retrieve the names of employees in the Research department who work more than 20 hours per week on the...
The relational schema for the Academics database is as follows: DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode)...
The relational schema for the Academics database is as follows: DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode) ACADEMIC(acnum, deptnum*, famname, givename, initials, title) PAPER(panum, title) AUTHOR(panum*, acnum*) FIELD(fieldnum, id, title) INTEREST(fieldnum*, acnum*, descrip) Some notes on the Academics database: An academic department belongs to one institution (instname) and often has many academics. An academic only works for one department. Research papers (PAPER) are often authored by several academics, and of course an academic often writes several papers (AUTHOR). A research field...
1. Joint frequency distributions are used to display: Select one: a. the cumulative distribution of a...
1. Joint frequency distributions are used to display: Select one: a. the cumulative distribution of a variable with two possible outcomes. b. the histograms of two variables analyzed simultaneously. c. the relative frequency of two variables. d. the number of occurrences at each of the possible joint occurrences of two variables. 2.For which data collection method is it most important to have a polished-looking survey form? Select one: a. Telephone survey b. Experimental design c. Written questionnaire d. Personal interview...
EMPLOYEE Field Name EMP_ID EMP_LNAME EMP_MI EMP_FNAME EMP_SEX EMP_AGE EMP_SALARY EMP_HIREDATE DEPT_CODE Table: DEPARTMENT DEPT_CODE BIOL...
EMPLOYEE Field Name EMP_ID EMP_LNAME EMP_MI EMP_FNAME EMP_SEX EMP_AGE EMP_SALARY EMP_HIREDATE DEPT_CODE Table: DEPARTMENT DEPT_CODE BIOL CPTR HIST MATH RELB Data Type Text Text Text Text Text Number Currency Date/Time Text DEPT_TITLE Biology Computer Science History Mathematics Religion    Field Name DEPT_CODE DEPT_TITLE Data Type Text Text INSTRUCTIONS Use SQL commands to create the tables and enter the data shown above using MS Access. Write the following SQL statement given below: 1. 2. 3. 4. 5. 6. 7. 8. 9....
Appraisal Approaches There are five techniques for designing evaluations to measure performance. (1) The comparative approach...
Appraisal Approaches There are five techniques for designing evaluations to measure performance. (1) The comparative approach takes the performance of one employee and assesses it side-by-side with the performance of other employees. (2) Evaluations based on the extent to which individuals have certain characteristics or traits desirable for company success fall under the attribute approach. (3) The behavioral approach focuses on the behaviors an employee must exhibit to be effective on the job. (4) Evaluations that concentrate on objective elements...
A comprehensive employee appraisal is often made up of several different methods of performance evaluation. You...
A comprehensive employee appraisal is often made up of several different methods of performance evaluation. You can choose to use just one evaluation process when judging an employee's performance, but when you use multiple evaluation methods you are able to get a broader picture of the areas where the employee needs improvement and what recommendations you should make to support employee development. Self-Evaluation The self-evaluation is often effective when teamed up with a performance review. The employee is asked to...
InstantRide is the new ride sharing application in the city and it has just started its...
InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users...
Consider the Ritz-Carlton with respect to management control, and decide whether the Ritz-Carlton exemplifies management control...
Consider the Ritz-Carlton with respect to management control, and decide whether the Ritz-Carlton exemplifies management control in an empowered setting or does not. Ritz-Carlton sets performance measures for maintaining its impressive reputation and ensures that employees see how they contribute. The measures are based on the key factors behind the company's success: its mystique, employee engagement, customer engagement, product service excellence, community involvement, and financial performance. Financial performance is viewed as the result of achieving the other goals. For each...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT