Help With Average Check

Hello Sql Expert!

I am trying to create a query that i can use to find the Average Check for transactions sold with a particular product.

The sql table i'm working with looks like this

ORDERID PRODUCT PRICE COUNT PAID
00001 burger 1.00 1 1.00

00001 hotdog 2.00 2 4.00
00001 drink 1.00 1 1.00

00001 shake 2.00 1 2.00
00002 burger 1.00 2 2.00
00002 shake 2.00 5 10.00
00003 hotdog 2.00 1 2.00

I would like to create something that will give me the average check for every product

ex
PRODUCT AVG CHECK
burger 10
shake 10
hotdog 5
drink 8

I created a query that could give me the % of each product that are ordered alone. I tried modifying it to give me avg check but ran into problems because the when i use max(product) to aggergate the field, it uses the products with the highest first character in the alphabet thus it products with V's and Y's get a lot more results (

Is there an easy way to do this by creating a temp table or nested query?

I can create a nested query to give me the average check for only one product at a time. I'm looking for something that can group the average check by all product.

Any help would be greatly appreciated!

Thank you so much!