SELECT
AVG(B.Score) AS averageScore,
A.title
FROM B left JOIN A ON A.id= b.titleId
GROUP BY A.id, B.titleId,A.title
ORDER BY AVG(B.Score) DESC
AVG(B.Score) AS averageScore,
A.title
FROM B left JOIN A ON A.id= b.titleId
GROUP BY A.id, B.titleId,A.title
ORDER BY AVG(B.Score) DESC
SELECT AVG(isnull(B.Score,0)) AS averageScore, A.title FROM A LEFT JOIN B ON A.id= b.titleId
GROUP BY A.id, B.titleId,A.title
ORDER BY AVG(isnull(B.Score,0)) DESC
isnull(AVG(B.Score),0) AS averageScore,
A.title
FROM A
left JOIN B
ON A.id= b.titleId
GROUP BY A.title
ORDER BY averageScore DESC