jessicasmith_lab4.vsd
| ID | Engagement Date | Engagement Time | Type of menu | Number of Attendees | Assistant Chef assigned | Employees assigned | Payment method | Deposit amount | Deposit paid date | Total charges | Balance paid date |
| ID | Customer Name | Phone Number | Address | E-mail address | Approved credit r not |
| ID | Employee Name | Position held |
| ID | Menu Type | Special diet | Description |
| 1 | Appetizer | Kocher or Vegeterian |
|
| 2 | Main Course | |
|
| 3 | Salad | |
|
| 4 | Dessert | |
|
| ID | Company's main activity | Directors |
| 2 | Four course gourmet dinner set for groups of two to forty | James Caren |
SELECT DISTINCTROW *
FROM [Customer Engagements];
SELECT DISTINCTROW *
FROM [Menu Items];
TRANSFORM Avg([Customer Engagements].[Payment method]) AS [AvgOfPayment method]
SELECT [Customer Engagements].[Engagement Date], [Customer Engagements].[Employees assigned], [Customer Engagements].[Balance paid date], Avg([Customer Engagements].[Payment method]) AS [Total Of Payment method]
FROM [Customer Engagements]
GROUP BY [Customer Engagements].[Engagement Date], [Customer Engagements].[Employees assigned], [Customer Engagements].[Balance paid date]
PIVOT [Customer Engagements].[Type of menu];
TRANSFORM Count([Customer Engagements].[Engagement Date]) AS [CountOfEngagement Date]
SELECT [Customer Engagements].[Deposit paid date], [Customer Engagements].[Type of menu], [Customer Engagements].[Deposit amount], Count([Customer Engagements].[Engagement Date]) AS [Total Of Engagement Date]
FROM [Customer Engagements]
GROUP BY [Customer Engagements].[Deposit paid date], [Customer Engagements].[Type of menu], [Customer Engagements].[Deposit amount]
PIVOT [Customer Engagements].[ID];
jaylee1
