codebase_community Database Schema

Database Description

Database for codebase community.

Schema Structure
Schema information not available for this database.
Example Queries

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

Difficulty: simple

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

Difficulty: moderate

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

Difficulty: simple

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

YEAR(CreationDate) = 2010;

Difficulty: simple

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

Difficulty: simple
Back to Database Explorer