I have two tables:

```

   PRODUCT           ITEM
- PRODUCT_ID      - ITEM_ID
- PRODUCT_DESC    - STORE_ID
- VENDOR_CODE     - PRODUCT_ID
                  - ITEM_PRICE

```

The PRODUCT table is for listing the details of each product that is sold at the store, and the ITEM table is essentially the inventory of each story, listing what products are in each store and their prices. 

I want to have a function which returns the product description, number of items (COUNT), and the average price of the items for all items of the same product type. However, I also want to have the condition that only products with more than 10 items are to be listed in the output.

This is what I have so far:

```
SELECT PRODUCT.PRODUCT_DESC AS Description,
       COUNT(ITEM.ITEM_ID) AS Count,
       AVG(ITEM.ITEM_PRICE) AS [Average Price]
FROM PRODUCT, ITEM
WHERE PRODUCT.PRODUCT_ID = ITEM.PRODUCT_ID
AND COUNT(ITEM.ITEM_ID) > 10;

```

I am using Access SQL, I would be grateful for any help!