Principles of Database Management

Write an SQL query to list the customer ID, number of guests, seating date, seating cost, and seating tip for all customers who were served at a table in the area with ID number 14. Place the list in ascending order by seating date and then customer ID SAMPLE DATA BASE (Key fields are underlined.) Employee \begin{tabular}{l|l|l|l|l|l|l|l|} \hline EMP_ID & EMP_FNAME & EMP_LNAME & EMP_STREET & EMP_CITY & EMP_STATE & EMP_ZIP & EMP_START_DATE \\ \hline \end{tabular} Table Area Customer Assignment Seating