Assume 3 tables like this:

**Teacher:** 

```
teacher_id, name, ... 

```

**Student:** 

```
student_id, teacher_id, ... 

```

**Class:** 

```
class_id, teacher_id, ... 

```

Is there a SQL query to get how many students and classes are assigned to every teacher? 

Result should be something like this:

```
teacher_id  name    students    classes 
t_001       AAA        3           2 
t_002       BBB        1           2 
...

```