SQL

SQL management 2009-2014 Create a view that shows the waiterID, last name and total amount of sales money made by each waiter. Sales should be calculated from the quantity of coffees sold plus tips. If a waiter has made no sales, display 0 instead.

Type your answers below or upload a valid .SQL file.

Example Output

*TABLE*

waiterId lastName Sales ----------- ------------------------------ ------ 1 Andresson $6.50 2 Dewitt $12.00 3 Dewitt $17.00 4 Andresson $18.50 5 Smallsbury $3.50 6 Lim $0.00