I have this query:

```
SELECT * 
FROM `classes` 
JOIN `classes_students` 
ON `classes`.`id` = `classes_students`.`class`

```

And I need to add condition for selecting just classes, in which are not currently logged student (user ID is not in classes\_students connected with class id) and also count how many students are in that class.

Table structure:
 classes: id, name, etc
 classes\_students: class\_id, user\_id, etc

Table data:

```
classes: 
1 | test 
2 | test2
3 | test3

classes_students:
1 | 1
1 | 2
2 | 3
3 | 4
3 | 5

```

Expected output if im user with id 1:
classes names (with number of students in):

```
2 (1 student)
3 (2 students)

```

All this in one query. It is possible? If yes, how?