Part $1$: Consider the following database schema. For to$-$go orders, tableNo

and emplID are NULL. For to$-$go orders and current orders, tip is NULL.

MenuItem$($itemName$,$ price$)$

Order$($orderNo$,$ tableNo, time, date, emplID, tip$)$

Server$($emplID$,$ emplName$)$

MenuItemOrder$($itemName$,$ orderNo, quantity$)$

HoursWorked$($emplID$,$ date, hours$)$

$1.$ Write the following mySQL queries:

a$)$ Give the total price of order $56.$

b$)$ For each server who has fallen short of making $$5\mathrm{.}00$ per hour worked

in tips today, report the employee ID and the shortfall amount.

c$)$ Remove the lobster bisque from table $3$s current order.

d$)$ Reassign all of Adam Baker$$s current orders to Charles Dugue.

e$)$ For each order, list the employee ID and tip. Output the results by

employee ID increasing then tip decreasing.

$2.$ Describe the output table for the following query:

SELECT COUNT$(*)$

FROM Order

WHERE tableNo IS NULL AND date $=$ CURDATE$()$;