I have a table with 3 columns, which is "year", "students\_count" and "faculty".
And I want to find out what is the biggest number of "students\_count" for each different faculty.

The table looks like this:

```
year| students_count| faculty
------------------------------------
2001| 50            | Business
2002| 60            | Business
2003| 40            | Business
2001| 20            | Engineering
2002| 10            | Engineering
2003| 50            | Law

```

```
SELECT year,max(students_count),faculty FROM table;

```

(it doesn't work) 

```
year| students_count| faculty
-----------------------------------
2002| 60            | Business
2001| 20            | Engineering
2003| 50            | Law

```