The customer wants me to count all the sales that has an especific type of item. For example:
Table: ITEMS, this are the items that the customer sales.
| Item | CodTypeItem |
|---|
| AA100 | 01 |
| AA900 | 01 |
| AC600 | 03 |
| PA333 | 02 |
| |
TABLA: TypeItem, this are the cateroies of the items
| CodTypeItem | DesTypeItem |
|---|
| 01 | FOOD |
| 02 | DRINKS |
| 03 | OTHER |
TABLA: Sales,
| ID | Clien | Date | Total |
|---|
| 1 | Coca | 20161210 | 555 |
| 2 | Pepsi | 20161211 | 2156 |
| 3 | Pepsico | 20161213 | 100 |
TABLA: SalesDet, sales detail.
| ID | ITEM | TOTAL |
|---|
| 1 | AA100 | 1326 |
| 1 | PA333 | 200 |
| 2 | AA100 | 100 |
| 3 | AC600 | 667 |
| | |
The customers wants a table like this
| Type | Numer of sales | avg amount per sale | |
|---|
| Food | 2 | 500 | |
| drink | 3 | 123 | |
| other | 6 | 900 | |
