codebase_community Database Schema

SQL Query:

SELECT T1.Title FROM posts AS T1 INNER JOIN users AS T2 ON T1.OwnerUserId = T2.Id WHERE T2.DisplayName = 'Vebjorn Ljosa'

Evidence:

"Vebjorn Ljosa" is the DisplayName; last edited refers to LastEditorUserId

SQL Query:

SELECT T2.UserId FROM users AS T1 INNER JOIN postHistory AS T2 ON T1.Id = T2.UserId INNER JOIN posts AS T3 ON T2.PostId = T3.Id WHERE T3.ViewCount >= 1000 GROUP BY T2.UserId HAVING COUNT(DISTINCT T2.PostHistoryTypeId) = 1

Evidence:

having at least 1000 view refers to Views > = 1000; user refers to UserId

SQL Query:

SELECT SUM(DISTINCT FavoriteCount) FROM posts WHERE Id IN ( SELECT PostId FROM postHistory WHERE UserId = 686 AND STRFTIME('%Y', CreationDate) = '2011' )

Evidence:

in 2011 refers to year (CreatinDate) = 2011

SQL Query:

SELECT COUNT(id) FROM votes WHERE STRFTIME('%Y', CreationDate) = '2010'

Evidence:

YEAR(CreationDate) = 2010;

SQL Query:

SELECT Body FROM posts WHERE id = ( SELECT ExcerptPostId FROM tags ORDER BY Count DESC LIMIT 1 )

Evidence:

most popular tag refers to Max(Count); excerpt from refer to ExcerptPostId