I have the following table structure and i want count all room types from Reservation table.
I want to have something like this:
Roomtype :double 3
 :simple 5 
It is possible to make this?

![enter image description here](https://i.stack.imgur.com/CcaQp.jpg)

I only managed to count all rooms from reservation table 

`SELECT COUNT(Room_ID)AS NumarRezervari
FROM dbo.Reservation WHERE MONTH(Data_Check_in)=5`