b) Mostra el titol de les 100 primeres preguntes amb el TagName 'average' ordenat de forma alfabetic

1

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

/*
b) Mostra el titol de les 100 primeres preguntes amb el TagName 'average'
ordenat de forma alfabetica per tag i titol.
*/

SELECT TOP 100 A.Title, B.TagName
FROM Posts A
INNER JOIN Tags B
ON A.Tags = B.TagName
WHERE B.TagName LIKE '%average%';

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results