How to get count or total of column (field)

lightningrod66

I am not having any luck getting the count or total of a column (field). For example, if I have the following:

EMPLOYEE - - - DAYS_WORKED
John - - - - - - - - - - 5
Steve - - - - - - - - - 7
Linda - - - - - - - - - 3
Rob - - - - - - - - - - 4

I need to get a count of how many employees (4) and total days worked (19). I have tried using COUNT(EMPLOYEE) and SUM(DAYS_WORKED) but they do not work.

bradgrafelman

Worked fine for me:

mysql> SELECT * FROM employee_times;
+----------+-------------+
| employee | days_worked |
+----------+-------------+
| John     |           5 |
| Steve    |           7 |
| Linda    |           3 |
| Rob      |           4 |
+----------+-------------+
4 rows in set (0.00 sec)

mysql> SELECT COUNT(employee), SUM(days_worked) FROM employee_times;
+-----------------+------------------+
| COUNT(employee) | SUM(days_worked) |
+-----------------+------------------+
|               4 |               19 |
+-----------------+------------------+
1 row in set (0.03 sec)