Question: 8. Write an SQL Query to list the employees first name, SSN, Project Number, and the project name for all female employees who have worked

8. Write an SQL Query to list the employees first name, SSN, Project Number, and the project name for all female employees who have worked more than 25 hours on any one project. Sort the list by SSN.

9. Write an SQL Query to list the employees first name, SSN, and their dependents first name, and dependents birth date.

10. Write an SQL Query to list the employees first name, employees birth date, and their dependents first name and dependents birth date. The list should include both sons and daughters, but not spouses.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

18. Write an SQL that will list the employees first name, and dependents first name and dependents birth date of all dependents who are less than 10 years old based on the date the query was run. 19....

Chapter 4 1. Write a query that will select all columns from the projectAssignment table without using the (*) in your query. You may wish to use the DESCRIBE command to examine the structure of the...

2. Write an SQL Query that will produce a list of Employees first name, and their Department Names. Show the SQL below: 3. Write an SQL Query that will produce a list of Employees first name, and...

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

file tax form for filing jointly with married couple with children CORRECTED (if checked) PAYER'S name, street address, city or town, state or province, country, ZIP or foreign postal code, and...

I am doing tax return project. attachments are the materials professor provide. He wants me to do a current year engagement file (Similar with prior year engagement file). AC 371 Tax Return Project...

Create HR database with the following tables. 1 2. Table 2: Departments 5. Table 5: Regions \begin{tabular}{|l|l|l|l|} \hline Column Name & Null? & Type \\ \hline REOICN_1D & NOr NJLL & NUNBER \\...

This is a project for a tax class. The facts tab contains the 20 problems that need to be entered into the other tabs. Is this something you could help me with? I will tip nicely for good work. Elf...

this is ACCESS work i need you to PROVIDE what id put in queries to get the answers at the bottom of the screen. PLEASE be clear will leave good review CS&E 2111 IN LAB 9 Download from Simnet: CSE...

Kyle's Competing Job Offers. Kyle, after an arduous post-graduation job search, has received an offer of the following three different country posts with a major multinational company. Each of the...

The binomial distribution applies only to cases involving two types of outcomes, whereas the multinomial distribution involves more than two categories. It is helpful to develop the technical skill...

When Faith Fitzgerald, MD wrote about "the dark side of being thin," she was attacking the prevalent assumption that:Multiple Choice 5 points

Javier Pena has always been interested in financing artistic projects. He has recently been offered two financing opportunities in the fashion industry: financing a new line of avant-garde youth...