1.Update all the DSK room type to KEXN Table: Practice Exercise table

1.Update all the DSK room type to KEXN
Table: Practice Exercise table

2.Find the total roomnights for the following rate categories in which the reservations were made in Dec 2002
XMAS
LIKE
Table: Practice Exercise table

3.Please separate the Year and Month from the ″Yearmonth – Check-out″
Table: 2002

4.Find the Average Daily Rate (Rev / Roomnights) by hotel (US properties only) and by month (between Apr 02 and Jun 02)
Table: System Size 2004-03-01
2002

5.How many hotels are NOT in the system as of 3/1/04 but in the 2002 data set?
Table: System Size 2004-03-01
2002

6.Please add one additional column and providing the booking lead time (Arrival Date – Booking Date)
Table: Practice Exercise table
link: http://wongsteve.com/BIProject.zip