Reference no: EM131109560
Instructions: Use the table structure in HR schema. Show your codes and show the print screen of results.
1. Write a query to display all unique job codes from the EMPLOYEES table.
2. Display the last name concatenated with the job ID (separated by a comma and space) and name the column Employee and Title.
3. Display the last name, job ID, and start date for the employees with the last names of Matos and Taylor. Order the query in ascending order by start date.
4. List the last name and salary of employees who earn between $5,000 and $12,000 and are in department 20 or 50. Label the columns Employee and Monthly Salary, respectively.
5. Displays the last name and hire date for all employees who were hired in 1994.
6. Display the last name and job title of all employees who do not have a manager.
7. Displays the employee number, last name, and salary of all employees who earn more than the average salary. Sort the results in order of ascending salary.
8. Displays the last name, department number, and job ID of all employees whose department location ID is 1700.
9. Create a view showing total number of employees.
10. Create a view showing employee ID, first name, last name, hire date and salary.
|
Inverse market demand curve
: Phillip Haynes is the controller of a company that has the sole authority to manufacture your product. The inverse market demand curve is C(Q) =2Q +Q^2 . Your total cost equation is . What is the output you should produce, the price you should charge..
|
|
Computer-controlled milling machine will cost
: A computer-controlled milling machine will cost Ajax Manufacturing $65,000 to purchase plus $4,700 to install. If the machine would have a salvage value of $6,600 at EOY 20, how much could Ajax charge annually to depreciation of this equipment? Ajax ..
|
|
What is the cause of the high unemployment rate
: What is the cause of the high unemployment rate? One side says there is not enough government spending. The other says it's a structural problem--people who can't move to take new jobs because they are tied down to burdensome mortgages or firms that ..
|
|
Prove that the difference of two odd integers is even
: Prove that the difference of two odd integers is even. Give a justification at each step. Prove that the sum of any two rational numbers is a rational number. Give a justification at each step
|
|
Write a query to display all unique job codes
: Write a query to display all unique job codes from the EMPLOYEES table. Display the last name concatenated with the job ID (separated by a comma and space) and name the column Employee and Title
|
|
Calculate the dead weight loss associated with moral hazard
: Suppose demand (DU) for health care is given by P= -Q+50.(QAenotes quantity demanded of number of visits to the doctor, and A denotes the price of the visit. Du is graphed below. Graph demand for doctor's visits with full insurance (coinsurance rate ..
|
|
Describe the reasoning that has led each little girl
: Imagine three little girls sitting in a circle, each wearing either a red hat or a white hat (no girl can see the color of her own hat). Suppose that all the hats are red. When the teacher asks if any student can identify the color of her own hat, th..
|
|
General effectiveness of the current regulatory environment
: Identify and discuss the roles of TWO (2) government institutions (organizations, agencies) that guide and/or regulate technology in the USA. Also, comment on the general “effectiveness” of the current regulatory environment
|
|
What is combined incremental state-federal income tax rate
: Your firm is in a major industrialized state, which has a state corporate tax rate of 9.5% of taxable income. If your firm has a gross income of $500,000, operating expenses of $275,000, and depreciation charges of $75,000: a) What is the taxable inc..
|