Listing the name and salary of all employees

Assignment Help Computer Engineering

Reference no: EM1333268

1. List the name, address, and date of birth of all female employees. Order the list alphabetically by last name.

2. List the name and salary of all employees in the Research department. Order the list in decreasing order of salaries.

3. List the name and hours worked per week for each employee who works on the Reorganization project. Order the list by hours worked in decreasing order and by last name within each amount of hours.

4. List the name of all employees directly supervised by Franklin Wong. Order the list by employee last name.

5. List the average salary of the employees of the Research department.

6. List the name of each department and the name of the department manager. Order the list by department name

7. For every project located in Houston, list the project name, the controlling department name, and the department manager's name. Order the list by project name.

8. For all employees with children, list the (first and last) name of the employee and the first name of the child. Order the list by last name of the employee and first name of the child. Hint: Be careful that you do not list the spouses, only the children.

9. List the (first and last) name of each employee and the name of the employee's spouse, if known. Hint: Be careful here; this uses a different operation than the previous question. You want to list all the employees, not just the ones who list a spouse.

10. List the (first and last) name of each employee who has no dependents. Hint: Remember the set operations.

Reference no: EM1333268

Questions Cloud

Calculate the level of excess supply : Suppose demand and supply conditions in the competitive market for unskilled labor

Industry reinvests of earnings in the firm : If the rate of return earned on reinvested funds is 15 percent also the industry reinvests 40 percent of earnings in the firm, what must be the discount rate.

Reasonable risk and unreasonable risk : Explain if there was a "reasonable risk" or "unreasonable risk" involved in this case. Was the plaintiff acting prudently? Explain.

Explain converting spoken words in digital text : Explain Converting spoken words in digital text and digitized voice message

Listing the name and salary of all employees : List the name and hours worked per week for each employee who works on the Reorganization project. Order the list by hours worked in explaning order and by last name within each amount of hours.

Explanation of how hr works with management : Explanation of how HR works with management - How does the department manager work with HR to ensure an accurate reflection of the skills and experience required through these three processes?

Investment policy prevent investors from optimizing returns : Do you think working with an investment policy may prevent investors from optimizing their returns? Is it beneficial to investors?

Increasing sales in the market : Apple's PowerBook would be classified as a Specialty Good in terms of behavioural effect on consumers.

Suppose that you are the top marketing manager : Suppose that you are the top marketing manager for the Pepsi-Cola Co. You are engaged in an intense battle for market share in domestic beverage market with Coca-Cola Co.

User Account

All Pages