codebase_community Database Schema

SQL Query:

SELECT T1.Id, T2.Title FROM users AS T1 INNER JOIN posts AS T2 ON T1.Id = T2.OwnerUserId ORDER BY T2.Score DESC LIMIT 1

Evidence:

the highest score refers to MAX(Score); owner's name refers to DisplayName;

SQL Query:

SELECT T1.Score FROM comments AS T1 INNER JOIN posts AS T2 ON T1.PostId = T2.Id WHERE T1.CreationDate = '2010-07-19 19:19:56.0'

Evidence:

created on 7/19/2010 7:19:56 PM refers to CreationDate = '2010-07-19 19:19:56.0'

SQL Query:

SELECT COUNT(id) FROM votes WHERE BountyAmount >= 30

Evidence:

bounty amount over 30 refers to BountyAmount > = 30;

SQL Query:

SELECT COUNT(T1.Id) FROM users AS T1 INNER JOIN postHistory AS T2 ON T1.Id = T2.UserId WHERE T1.DisplayName = 'Daniel Vassallo'

Evidence:

DisplayName = 'Daniel Vassallo';

SQL Query:

SELECT LastEditDate, LastEditorUserId FROM posts WHERE Title = 'Detecting a given face in a database of facial images'

Evidence:

Title = 'Detecting a given face in a database of facial images';