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