----- ----Write a query to find PersonID,Name,Number of friends, and sum of marks of person who have friends with total score greater then 100 ----------- -------------------START---------------------------------------------------------------------------- select * from [ Person_Table] SELECT * FROM [dbo].[Friend] WITH CTE1 AS ( SELECT A.PersonID, count (A.PersonID) as "No of friends", SUM(B.Score) as "Total Marks" FROM [dbo].[Friend] A INNER JOIN [ Person_Table] B ON A.FriendID = B.PersonID group by  A.PersonID Having SUM(B.Score) >100 ) SELECT P.*,CTE1.[No of friends],CTE1.[Total Marks] FROM [ Person_Table] P INNER JOIN CTE1 ON CTE1.PersonID=P.PersonID --------------END----------------------------------------------------------------------------------------------------