I am trying to make a drop down list in my website showing a list of available topics, however each topic is linked with a list of titles that belong to, how can I show the number of available titles associated with this topic using an sql query.

this is the structure of my tables :

**Topics Table**

```
TopicId (int) , TopicTitle (varchar 50)

```

---

**Titles Table**

```
TitleId (int), Title (varchar 50), TopicId

```

and the structure of the drop down list is for example :

Sports 10

Education 4

...