Find all rooms that are unoccupied on both the night of March 20, 2010 and every night during the date range March 12, 2010 through March 14, 2010 (inclusive). List room code and room name, sort by room code A-Z.

EXPECTED:

RoomCode	RoomName
HBB	Harbinger but bequest
IBD	Immutable before decorum
MWC	Mendicant with cryptic
TAA	Thrift and accolade

TABLES:

rooms:

RoomCode	RoomName	Beds	bedType	maxOcc	basePrice	decor
AOB	Abscond or bolster	2	Queen	4	175	traditional
CAS	Convoke and sanguine	2	King	4	175	traditional
FNA	Frugal not apropos	2	King	4	250	traditional
HBB	Harbinger but bequest	1	Queen	2	100	modern
IBD	Immutable before decorum	2	Queen	4	150	rustic
IBS	Interim but salutary	1	King	2	150	traditional
MWC	Mendicant with cryptic	2	Double	4	125	modern
RND	Recluse and defiance	1	King	2	150	modern
RTE	Riddle to exculpate	2	Queen	4	175	rustic
TAA	Thrift and accolade	1	Double	2	75	modern

reservations: (to much data)

Field	Type	Null	Key	Default	Extra
CODE	int	NO	PRI	null
Room	char(5)	YES	MUL	null
CheckIn	date	YES		null
Checkout	date	YES		null
Rate	float	YES		null
LastName	varchar(15)	YES		null
FirstName	varchar(15)	YES		null
Adults	int	YES		null
Kids	int	YES		null