select * from MenuCard

select * from MenuItem

select * from MenuItem
where MenuCardName = 'Drinking'
order by price DESC

select count(*) from MenuItem
where MenuCardName = 'Drinking'

select MIN(Price) as 'MIN', MAX(PRICE) as 'MAX', AVG(PRICE) as 'AVG' from MenuItem

select MIN(Price) as 'MIN', MAX(PRICE) as 'MAX', AVG(PRICE) as 'AVG', MenuCardName from MenuItem
Group by MenuCardName
order by MenuCardName asc

select MIN(Price) as 'MIN', MAX(PRICE) as 'MAX', AVG(PRICE) as 'AVG', TypeOfItem from MenuItem
Group by TypeOfItem

select MIN(Price) as 'MIN', MAX(PRICE) as 'MAX', AVG(PRICE) as 'AVG', TypeOfItem from MenuItem
where MenuCardName = 'Drinking'
Group by TypeOfItem

select * from MenuItem
where MenuItem.MenuName like '%coffee%'

select * from MenuItem
where MenuItem.MenuDescription like '%coffee%'

select * from MenuItem
where MenuItem.MenuDescription like '%coffee%' or MenuItem.MenuName like '%coffee%'

select * from Booking

select * from Booking
where DayAndTime between '2018-02-16 00:00:00'  AND '2018-02-16 23:59:59'

select * from Booking
where DATEPART(HOUR, DayAndTime) between 11 AND 14

select * from Booking
where DATEPART(YEAR, DayAndTime) = DATEPART(YEAR, GETDATE()) 
 AND DATEPART(MONTH, DayAndTime) = DATEPART(MONTH, GETDATE())
 AND DATEPART(DAY, DayAndTime) = DATEPART(DAY, GETDATE())


 select  Booking.CustomerNo from Booking

 select count(*), sum (Seats) from RestaurantTable
 where RestaurantTable.WindowSite = 1







