Ejercicios

0

Please login or register to vote for this query.

(click on this box to dismiss)

Project Management

Q&A for project managers

--Encontrar el título y fecha de las 5 preguntas con mayor 
--score que contienen el tag ‘python’

SELECT Posts.Title, Posts.CreationDate
FROM Posts, PostTags, Tags
WHERE PostTags.PostId = Posts.Id 
AND Tags.Id = PostTags.TagId 
AND Posts.ParentId IS NULL 
AND Tags.TagName = 'python'
ORDER BY Posts.Score DESC
--OFFSET 0 ROWS FETCH FIRST 5 ROWS ONLY;

Enter Parameters

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