Write the SQL code (must be TYPED out please, I cannot read script or bad penmanship).  Mainly using PostgresSQL

that will, for each employee, yield the total # of HOURS worked, and the total charges stemming from those hours worked.

 

The results of running this query are shown below:

Write the SQL code (must be TYPED out please, I cannot read script or bad penmanship).  Mainly using PostgresSQL

that will, for each employee, yield the total # of HOURS worked, and the total charges stemming from those hours worked.

 

The results of running this query are shown below:

 

 EXPLAIN all lines of code please. If you cannot read some of the numbers or letters, don't worry about it. Make it up and use your judgement. I'll understand what you're referring to.

Transcribed Image Text:

▬▬▬▬▬▬▬▬ 29. Using the data in the ASSIGNMENT table: wwwwww. AAAAA ASSIGN NUM ASSIGN_DATE PROJ_NUM EMP NUM ASSIGN JOB ASSIGN_CHG_HR ASSIGN HOURS ASSIGN_CHARGE 1001 103 3.5 1002 117 1003 117 1004 103 108 104 113 103 115 117 105 108 115 104 103 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 22-Mar-04 16 22-Mar-04 22 22-Mar-04 18 22-Mar-04 18 22-Mar-04 25 22-Mar-04 22 22-Mar-04 25 22-Mar-04 18 23-Mar-04 15 23-Mar-04 15 23-Mar-04 25 23-Mar-04 18 23-Mar-04 25 23-Mar-04 22 23-Mar-04 15 23-Mar-04 22 23-Mar-04 18 23-Mar-04 25 24-Mar-04 25 24-Mar-04 15 24-Mar-04 22 24-Mar-04 22 24-Mar-04 22 105 117 117 104 101 108 103 104 105 108 115 105 113 115 117 503 509 509 503 501 501 508 News Arbouch Ramoras Johnson Washington Joenbrood 503 501 509 5020 501 501 501 503 Bawangi VAliamson 502 509 509 501 502 501 501 502 184.50 $34.55 $34.55 384.50 396.75 196.75 $50.75 3.1 19.7 11.9 12.5 8.3 3.8 12.5 10.0 $84.50 396.75 $34.55 $105.00 396.75 396.75 $96.75 384.50 $105.00 $34.55 $34.55 $110.50 $125.00 $110.50 $110.50 $125.00 EMP NJM EMP_LNANE SunOfASSION_HOURS SumOfASSION_CHARGE 01 2.0 5.9 2.2 4.2 3.8 3387.50 $1,664.55 $1,218.70 $1,382 50 $840.15 $192.85 $1,276.75 $€49.54 09 5.6 2.4 4.3 3.4 2.0 2.8 6.1 4.7 3.8 2.2 4.9 write the SQL code that will, for each employee, yield the total number of hours worked and the total charges stemming from those hours worked. The results of running this query are shown below: 3.1 2.7 4.9 3.5 $295.75 $145.11 $69.10 $498.55 $212.85 $406.35 $192.85 $76.05 $541.80 $82.92 $451 50 $328.95 $193.50 $270.90 $515.45 $493.50 $131.29 $76.01 $541.45 $387.50 $290 35 $541 45 $437.50 ▬▬▬▬▬▬▬▬ 29. Using the data in the ASSIGNMENT table: wwwwww. AAAAA ASSIGN NUM ASSIGN_DATE PROJ_NUM EMP NUM ASSIGN JOB ASSIGN_CHG_HR ASSIGN HOURS ASSIGN_CHARGE 1001 103 3.5 1002 117 1003 117 1004 103 108 104 113 103 115 117 105 108 115 104 103 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 22-Mar-04 16 22-Mar-04 22 22-Mar-04 18 22-Mar-04 18 22-Mar-04 25 22-Mar-04 22 22-Mar-04 25 22-Mar-04 18 23-Mar-04 15 23-Mar-04 15 23-Mar-04 25 23-Mar-04 18 23-Mar-04 25 23-Mar-04 22 23-Mar-04 15 23-Mar-04 22 23-Mar-04 18 23-Mar-04 25 24-Mar-04 25 24-Mar-04 15 24-Mar-04 22 24-Mar-04 22 24-Mar-04 22 105 117 117 104 101 108 103 104 105 108 115 105 113 115 117 503 509 509 503 501 501 508 News Arbouch Ramoras Johnson Washington Joenbrood 503 501 509 5020 501 501 501 503 Bawangi VAliamson 502 509 509 501 502 501 501 502 184.50 $34.55 $34.55 384.50 396.75 196.75 $50.75 3.1 19.7 11.9 12.5 8.3 3.8 12.5 10.0 $84.50 396.75 $34.55 $105.00 396.75 396.75 $96.75 384.50 $105.00 $34.55 $34.55 $110.50 $125.00 $110.50 $110.50 $125.00 EMP NJM EMP_LNANE SunOfASSION_HOURS SumOfASSION_CHARGE 01 2.0 5.9 2.2 4.2 3.8 3387.50 $1,664.55 $1,218.70 $1,382 50 $840.15 $192.85 $1,276.75 $€49.54 09 5.6 2.4 4.3 3.4 2.0 2.8 6.1 4.7 3.8 2.2 4.9 write the SQL code that will, for each employee, yield the total number of hours worked and the total charges stemming from those hours worked. The results of running this query are shown below: 3.1 2.7 4.9 3.5 $295.75 $145.11 $69.10 $498.55 $212.85 $406.35 $192.85 $76.05 $541.80 $82.92 $451 50 $328.95 $193.50 $270.90 $515.45 $493.50 $131.29 $76.01 $541.45 $387.50 $290 35 $541 45 $437.50

Answer rating: 100% (QA)

To achieve the desired results as seen in the image provided we need to write an SQL query that will ... View the full answer