Answer Happy

Posted: **Sun May 15, 2022 10:15 am**

: Table And Reservation Queries 1 Are There Any Two Tops Available To Reserve 2 What Is The Size Of The Party Coming A 1 (30.07 KiB) Viewed 40 times

Table and Reservation Queries: 1- Are there any two-tops available to reserve? 2- What is the size of the party coming at 7:30? 3- What time will the party of 2 be arriving? 4- How many tables are available for reservation? 5- Can the party of 10 change their reservation to a party of 8?

TableNo Size IsReserved Filter Filter Filter 1 13 8 Y 23 4 Y 3 26 4 N 4 11 2 < Z Z 5 1 6

Reservation No Filter 1 158 ResDate Res Time PartyOf Filter Filter Filter 2022-05-09 2022-05-09 18:00:00 6 2 159 2022-05-09 2022-05-09 17:00:00 5 2022-05-09 2022-05-09 17:30:00 2 3 160 4 162 2022-05-09 2022-05-09 19:30:00 10 5 164 2022-05-09 2022-05-09 20:00:00 8