mysql 工时统计_有如下数据，要统计1月3号工时不足8小时的员工姓名及总工时，该sql语句该怎么写（用的mysql哈）...

登记时间 姓名 工时

2014-01-03 08:42:20 A 2

2014-01-03 16:18:02 B 2

2014-01-03 14:57:54 B 3

2014-01-03 14:54:03 B 2

2014-01-03 10:13:26 C 1

2014-01-03 13:55:30 D 6

2014-01-03 16:19:08 E 7

2014-01-03 14:45:42 F 4

2014-01-03 14:45:16 F 4

2014-01-03 16:13:20 G 2

2014-01-03 16:12:28 G 2

2014-01-03 16:15:26 H 2

2014-01-03 16:14:26 H 0

2014-01-03 16:13:50 H 2

2014-01-03 16:20:53 I 3

2014-01-03 16:20:11 I 3

2014-01-03 16:19:56 I 3

2014-01-03 16:21:18 I 3

2014-01-03 16:19:33 I 3

2014-01-03 16:21:05 I 3

2014-01-03 15:46:02 J 3

2014-01-03 15:46:53 J 3

2014-01-03 11:25:16 K 2

2014-01-03 13:57:21 K 4

2014-01-03 14:38:55 L 3

2014-01-03 14:37:23 L 2

2014-01-03 13:29:42 M 2

2014-01-03 16:48:45 M 6

2014-01-03 10:28:44 N 2

2014-01-03 09:10:13 N 5

2014-01-03 16:17:40 O 7

2014-01-03 16:24:09 O 6

2014-01-03 16:23:29 O 2

2014-01-03 16:11:29 P 4

注意，是总工时不足8小时哈