php - Select room availability in same table between 2 dates (using SQL) -

i search room availability.

table structure:

how fetch field room available in particular date, in pic there rid(13).

as understand, want rid noofrooms greater 0 in case need use group by group rows same rid. so:

select `rid`,`noofrooms` `roomavailability` group `rid` having `noofrooms`>0