Hey I'm having some trouble with this query, can someone please help?

[spoo30]

The query I have to make is:

List the combined total hours worked of all the academic staff per week, the maximum hours worked, minimum hours
worked, the name and subject of the academic staff who had the maximum hours , the name and subject of the academic staff who had the minimum hours worked.

The tables I ‘can’ use to get this from are:

(**Table**) ApprovedUnits (**Fields**): ApprovedID, EmployeeID, UnitCode

(**Table**) Employees (**Fields**): EmployeeID, FirstName, LastName

(**Table**) Timesheet (**Fields**): TimesheetID, EmployeeID, Date, Hours, WeekNo

(**Table**) Units (**Fields**): UnitCode, UnitName

This is the SQL query I have so far:

SELECT SUM(Timesheet.Hours), 
FROM Timesheet, Employees, Units
WHERE Timesheet.Hours < MAX
AND Employees.FirstName, Employees.LastName
;

This is all I have at the moment, I have no idea where to go from there, can someone please give me some pointers? Or ideas on how I can continue with this?

[Ratslinger]

Your question is not easy to answer. You provide general information while details are necessary. For example, the Hours field - is this only hours or is it hrs/min & what format (integer, time, timestamp). As an example SQL statement (not based upon your info) this is a totalling of time using hours & minutes:

SELECT CONCAT("HRS","MIN") AS "TTLTIME" FROM (SELECT CONCAT(((SUM(Minute ( "Time" )) + SUM((Hour ( "Time" )) * 60))  / 60), ':') AS "HRS",  MOD((SUM(Minute ( "Time" )) + SUM((Hour ( "Time" )) * 60)) ,60) AS "MIN" FROM "TimeCalc")

Here are some sites to help you develop your SQL: site 1, site 2. There are many more available. SQL is its’ own language & takes time to learn.