Using a subquery, list the partid and description of all parts where the number of units on hand is greater than the average of units on hand for all parts

SalesRep PK ReplD PK CustomerID int varchar(20) LastName FirstName CommissionRate decimal(10,2) LastName varchar(20) FirstName varchar(20) | OrderID | int decimal(10,2) E PK FK1 ReplD FK1 CustomerlD int ShipDate date Part PK,FK1 OrderlDint PK,FK2 PartIDint ItemClass ass char(4) decimal(10,2) decimal(10,2)