Create Script

CREATE TABLE [dbo].[Sales](

[Department] [nvarchar](50) NULL,

[price] [int] NULL

)

Sample data taken

Departmentprice

A 10

B 5

A 15

A 3

B 15

C 11

D 3

D 2

SELECT DEPARTMENT,PRICE FROM [DBO].[SALES] A

WHERE DEPARTMENT

IN(

SELECT DEPARTMENT FROM [DBO].[SALES] B WHERE

A.DEPARTMENT =B.DEPARTMENT

GROUP BY DEPARTMENT Having AVG(B.PRICE) >=10

)