Question

write the sql code to generate the total hours worked and the total charges made by all employees . the results are shown in fig.P7.8

Answer 1

Answer:

Select SUM(HOURS), SUM(CHARGES) from employees

Explanation:

The table structure is not given. So, I will assume that the table name is "employees", the columns to retrieve are "hours" and "charges"

Having said that, the function to retrieve the total of column is the sum() function.

So, the query is as follows:

Select ----> This means that the query is to retrieve from the table

SUM(HOURS), SUM(CHARGES) --- This represent the records to retrieve

from employees ---- This represents the table to retrieve from.