Question

Questions/queries: 1. Write the SQL code that will list design name and only the distinct design numbers in the CLIENT table, sorted by design number. DESIGN_J DESIGN_NA_ 15 Evergreen 18 Amber Wave 22 Rolling Tide 25 Starflight 2. Write a query to produce the total number of client hours and charges for each of the designs represented in the CLIENT table, sorted by design number. DESIGN_J Sum of CLIENT_ Sum of CLIENT_ 15 20.5 1806.52 18 23.7 1544.8 22 27 2593.16 25 19.4 1668.16 3. Write the SQL code required to generate the total client hours and total charges in the CLIENT table, listed by job code and job description, sorted by job code. JOB_CO JOB_DESCRIPTIC Sum_of_CLIENT_HOUR Sum_of_CLIE_ 500 Programmer 19.7 1664.65 501 Systems Analyst 32.7 3335.6 502 Database Designer 15.6 1770 503 Applications Design 3.8 192.85 509 Bio Technician 18.8 649.54

          Questions/queries:
1. Write the SQL code that will list design name and only the distinct design numbers in the
CLIENT table, sorted by design number.
DESIGN_J DESIGN_NA_
15 Evergreen
18 Amber Wave
22 Rolling Tide
25 Starflight
2. Write a query to produce the total number of client hours and charges for each of the designs
represented in the CLIENT table, sorted by design number.
DESIGN_J Sum of CLIENT_ Sum of CLIENT_
15 20.5 1806.52
18 23.7 1544.8
22 27 2593.16
25 19.4 1668.16
3. Write the SQL code required to generate the total client hours and total charges in the
CLIENT table, listed by job code and job description, sorted by job code.
JOB_CO JOB_DESCRIPTIC Sum_of_CLIENT_HOUR Sum_of_CLIE_
500 Programmer 19.7 1664.65
501 Systems Analyst 32.7 3335.6
502 Database Designer 15.6 1770
503 Applications Design 3.8 192.85
509 Bio Technician 18.8 649.54

Questions/queries:
1. Write the SQL code that will list design name and only the distinct design numbers in the
CLIENT table, sorted by design number.
DESIGNJ DESIGNNA
15 Evergreen
18 Amber Wave
22 Rolling Tide
25 Starflight
2. Write a query to produce the total number of client hours and charges for each of the designs
represented in the CLIENT table, sorted by design number.
DESIGNJ Sum of CLIENT Sum of CLIENT
15 20.5 1806.52
18 23.7 1544.8
22 27 2593.16
25 19.4 1668.16
3. Write the SQL code required to generate the total client hours and total charges in the
CLIENT table, listed by job code and job description, sorted by job code.
JOBCO JOBDESCRIPTIC SumofCLIENTHOUR SumofCLIE
500 Programmer 19.7 1664.65
501 Systems Analyst 32.7 3335.6
502 Database Designer 15.6 1770
503 Applications Design 3.8 192.85
509 Bio Technician 18.8 649.54

Added by Paul C.

Question

Please give Ace some feedback