SELECT
e.employeename
,CONVERT(VARCHAR, t.startdate, 111) as startdate
,SUM(t.hourstaken) as hourstaken
,d.activityname
FROM
employee e
INNER JOIN timesheet t ON e.employeeid = t.employeeid
INNER JOIN departmentactivity d ON e.departmentid = d.departmentid
WHERE
CONVERT(VARCHAR, t.startdate, 111) = '2012/04/10'
GROUP BY
e.employeeid
,e.employeename
,CONVERT(VARCHAR, t.startdate, 111)
,d.activityname
HAVING
SUM(t.hourstaken) < 7
ORDER BY
e.employeename