Use the Dependent table in the Company database to answer the following questions: 1. List the...
Fantastic news! We've Found the answer you've been seeking!
Transcribed Image Text:
Use the Dependent table in the Company database to answer the following questions: 1. List the Employee SSN (ESSN) and number of dependents for each employee. 2. List the Employee SSN (ESSN) and number of dependents for each employee but only list employees who have at least two dependents. 3. List the Employee SSN (ESSN), Sex, and number of dependents of that sex for each employee. Sort your list by Employee SSN. Use the Employee table in the Company database to answer the following questions: 4. What is the number of employees, number of unique salary values, total salary, and average salary for all employees? Use appropriate column headings for all calculated values. 5. What is the number of employees, number of unique salary values, total salary, and average salary broken down by Department? Only show departments that have at least two employees. Company Database Data Employee SSN 888665555 James E 333445555 Franklin T Wong FNAME M LNAME BDATE ADDRESS Sex SALARY SUPERSSN DNUMBER Borg 10-NOV-92 450 Stone, HoUston, TX M 55000 08-DEC-70 987654321 Jennifer S Wallace 20-JUN-86 987987987 George W Bush 29-MAR-84 638 Voss, Houston, TX 40000 888665555 291 Berry, Bellaire, TX 980 Dallas, Houston, TX 09 JAN-80 731 Fondren, Houston, TX M 3321 Castle, Spring. TX 43000 888665555 4. 25000 987654321 4. 123456789 999887777 666884444 Ramesh K Narayan 15-SEP-77 John Smith 30000 333445555 Alicia J Zelaya 19-JUL-83 25000 987654321 4 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX 38000 333445555 453453453 Joyce A English 31-JUL-87 25000 333445555 5. Department Dept Locations DNUMBER DLOCATION 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston DNUMBER DNAME MGRSSN 333445555 22-MAY-2003 MGRSTARTDATE 5 Research 4 Administration 987654321 01-JAN-2006 1 Headquarters 888665555 19 JUN-96 Project PNUMBER PNAME PLOCATION DNUMBER Bellaire Sugarland Houston 10 Computerization Stafford 20 Reorganization Houston Stafford 1 ProductX 2 ProjectY 3 Productz Works On SSN 123456789 123456789 PNUMBER HOURS 32.5 7.5 2 30 Newbenefits 666884444 3 40 453453453 20 453453453 2 20 Dependent DEPENDENT NAME Sex 333445555 2 10 ESSN 333445555 Alice 333445555 Theodore 333445555 Joy 987654321 Abner 123456789 Michael 123456789 Alice 123456789 Elzabeth BDATE RELATIONSHIP 333445555 10 05-APR-2001 Daughter M 25-OCT-2014 Son 03-MAY-1983 Spouse M 28-FEB-1987 Spouse M 01-JAN-2013 Son F 31-DEC-2013 Daughter F 05-MAY-1992 Spouse 333445555 333445555 999887777 999887777 10 10 20 10 F 30 10 30 10 987987987 987987987 987654321 10 35 30 30 20 20 987654321 15 Null 888665555 20 Use the Dependent table in the Company database to answer the following questions: 1. List the Employee SSN (ESSN) and number of dependents for each employee. 2. List the Employee SSN (ESSN) and number of dependents for each employee but only list employees who have at least two dependents. 3. List the Employee SSN (ESSN), Sex, and number of dependents of that sex for each employee. Sort your list by Employee SSN. Use the Employee table in the Company database to answer the following questions: 4. What is the number of employees, number of unique salary values, total salary, and average salary for all employees? Use appropriate column headings for all calculated values. 5. What is the number of employees, number of unique salary values, total salary, and average salary broken down by Department? Only show departments that have at least two employees. Company Database Data Employee SSN 888665555 James E 333445555 Franklin T Wong FNAME M LNAME BDATE ADDRESS Sex SALARY SUPERSSN DNUMBER Borg 10-NOV-92 450 Stone, HoUston, TX M 55000 08-DEC-70 987654321 Jennifer S Wallace 20-JUN-86 987987987 George W Bush 29-MAR-84 638 Voss, Houston, TX 40000 888665555 291 Berry, Bellaire, TX 980 Dallas, Houston, TX 09 JAN-80 731 Fondren, Houston, TX M 3321 Castle, Spring. TX 43000 888665555 4. 25000 987654321 4. 123456789 999887777 666884444 Ramesh K Narayan 15-SEP-77 John Smith 30000 333445555 Alicia J Zelaya 19-JUL-83 25000 987654321 4 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX 38000 333445555 453453453 Joyce A English 31-JUL-87 25000 333445555 5. Department Dept Locations DNUMBER DLOCATION 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston DNUMBER DNAME MGRSSN 333445555 22-MAY-2003 MGRSTARTDATE 5 Research 4 Administration 987654321 01-JAN-2006 1 Headquarters 888665555 19 JUN-96 Project PNUMBER PNAME PLOCATION DNUMBER Bellaire Sugarland Houston 10 Computerization Stafford 20 Reorganization Houston Stafford 1 ProductX 2 ProjectY 3 Productz Works On SSN 123456789 123456789 PNUMBER HOURS 32.5 7.5 2 30 Newbenefits 666884444 3 40 453453453 20 453453453 2 20 Dependent DEPENDENT NAME Sex 333445555 2 10 ESSN 333445555 Alice 333445555 Theodore 333445555 Joy 987654321 Abner 123456789 Michael 123456789 Alice 123456789 Elzabeth BDATE RELATIONSHIP 333445555 10 05-APR-2001 Daughter M 25-OCT-2014 Son 03-MAY-1983 Spouse M 28-FEB-1987 Spouse M 01-JAN-2013 Son F 31-DEC-2013 Daughter F 05-MAY-1992 Spouse 333445555 333445555 999887777 999887777 10 10 20 10 F 30 10 30 10 987987987 987987987 987654321 10 35 30 30 20 20 987654321 15 Null 888665555 20
Expert Answer:
Answer rating: 100% (QA)
SELECT COUNT AS Number of Employees COUNTDISTINCT SALARY AS Unique SalarySUMSALARY AS Total SalaryAV... View the full answer
Related Book For
Accounting and auditing research tools and strategies
ISBN: 978-1118027073
8th edition
Authors: Thomas Weirich, Thomas Pearson, Natalie Tatiana
Posted Date:
Students also viewed these accounting questions
-
Use a tax research database to answer the following questions: a. Paraphrase Code Section 61(a)(4). b. What is the general content of Code Section 166(d)? c. Find the precise authority within the...
-
Use WestlawNext Campus Research to answer the following questions regarding the Jensen 178 Cal. App. 4th 426 case: a. In what year was the case decided and by what court? b. Examine the headnote....
-
Use Spreadsheet 18.1 to answer the following questions about Executive Fruit. a. What would be the required external financing if the growth rate is 15% and the dividend payout ratio is 60%? b. Given...
-
What is the atomic weight of a hypothetical element consisting of two isotopes, one with mass= 64.23 amu (36.00%), and one with mass=65.32 amu ( 64.00%) ? [Topic: isotope and molecular weight] 64.93...
-
Suppose that the parts produced by a machine can have three different levels of functionality: working, impaired, defective. Let p1, p2, and p3 = 1 p1 p2 be the probabilities that a part is working,...
-
A student of the author measured the sitting heights of 36 male classmate friends, and she obtained a mean of 92.8 cm. The population of males has sitting heights with a mean of 91.4 cm and a...
-
The first volume of the Accountant's Index listed forensic-type articles under which categories?
-
Inara Serra Co. uses special journals and a general journal. The following transactions occurred during May 2012. May 1 I. Serra invested $50,000 cash in the business. 2 Sold merchandise to Morena...
-
Can exploiting workers to the extent they are regarded as modern slaves ever be regarded as ethical? Discuss how this ethical issue could be addressed from utilitarian, deontological and relative...
-
The folowing trial balance of Watervray Co. doss nat balanca. WATERWAY cO. TRIAL BALANCE JUNE 30, 2020 Debit Credit Cash $3.259 Accounts Receivable $2,852 Supplies 1,189 Equipmant 4,189 Accounts...
-
Can you help me with the questions I got wrong? Thank you! In December of each year, Eleanor Young contributes 10% of her gross income to the United Way (a 50% organization). Eleanor, who is in the...
-
Earnings before interest and taxes is $74,300. Interest is $8,162 and depreciation is $8,300. The tax rate is 34%. What is the cash coverage ratio?
-
How do endocrine disruptors interfere with hormonal signaling pathways, and what are the potential ecological and health consequences of exposure to these compounds ?
-
Can you elucidate the molecular mechanisms underlying the phenomenon of epigenetic inheritance and its implications in the regulation of gene expression across successive generations ?
-
You enter into a long position in one gold futures contract worth $500 per ounce. Contract size is 100 ounces. The initial margin is $2,500 per contract and the maintenance margin is $1,500 per...
-
The concept of shareholdervaluemaximization focuses on maximizing the value of equity.But in a finance balance sheet, we can see that thisis not quite the same as maximizing the value offirm? Why?...
-
The security characteristic line (SCL)A) plots the excess return on a security as a function of theexcess return on the market.B) allows one to estimate the beta of the security.C) allows one to e 2...
-
The Pletcher Transportation Company uses a responsibility reporting system to measure the performance of its three investment centers: Planes, Taxis, and Limos. Segment performance is measured using...
-
Assume that the taxpayer has a tax issue in which the only authorities on point are as follows: (a) a private letter ruling that favors the taxpayers position and (b) a Tax Court regular decision...
-
Identify the advantages and disadvantages of rules-based versus principles-based accounting standards.
-
Provide an example of utilizing the research navigation guide
-
The following trial balance was extracted from the books of A Scholes at the close of business on 28 February 19X7. Notes: (a) Stock 28 February 19X7 3,510. (b) Wages and salaries accrued at 28...
-
Express the vector \(\mathbf{v}=(1,2,3)\) as a linear combination of the vectors \(\mathbf{a}_{1}=(1,1,1), \mathbf{a}_{2}=(1,0,-2)\), and \(\mathbf{a}_{3}=(2,1,0)\).
-
T Morgan, a sole trader, extracted the following trial balance from his books at the close of business on 31 March 19X9: Notes: a) Stock 31 March 19X9 4,290. b) Wages and salaries accrued at 31 March...
Study smarter with the SolutionInn App