I need some help

I need to calculate the total hours of each employee and also show all the dates of each employee in a same table.

My Table is like below-

The output should be like this

CodePudding user response：

You can use GROUPING SETS for this

SELECT
  Employee = CASE WHEN GROUPING(t.Date) = 0 THEN t.Employee ELSE 'Total' END,
  t.Date,
  hours = SUM(t.hours)
FROM YourTable t
GROUP BY GROUPING SETS (
    (Employee, Date),
    (Employee)
);

db<>fiddle

The GROUPING() function tells you whether a column has been aggregated for that row