I have a 3 MySQL tables which I need to get results from and which are:

```
1. Towns
Fields Towncode and Townname

2. Students
Fields student_id,name,surname,address,streetcode,towncode,HeadOfFamily

3. Phonebank
Fields student_id,contacted,towncode

```

Now I need a mysql statement (a) to get the total number of households from the students table and also (b) the number of students contacted for that particular town.

up to step (a) I managed which and is extremely fast which is:

```
SELECT 
      t.towncode as towncode, 
      t.townname as townname, 
      (SELECT COUNT(*) 
          FROM students p 
          WHERE p.towncode=t.towncode 
            and p.student_hh='H') AS households
   FROM 
      towns t 
   ORDER BY 
      t.towncode ASC 

```

but I cannot manage to insert as well another SELECT STATEMENT to get the number of calls fr that particular town.

Can you kindly assist please?