Adam Lear
|
Registered User
|
- select v.id as voteid, p.id as [Post Link] from votes v j...
- Questions with both [android] and [arduino] tags
- SELECT TOP 100 ROW_NUMBER() OVER (ORDER BY CreationDate), *
- SELECT AVG(Score) FROM Posts WHERE OwnerUserId = 22656
- SELECT DATEADD(day, 210, '2012-11-27')
- SELECT TOP 10 q.Id as [Post Link], q.AcceptedAnswerId fro...
- WITH PostsCommentsAndEdits AS ( SELECT 'Post' AS ActionTy...
- SELECT TOP 10 OwnerUserId as [User Link], AVG(Score) FROM...
- Homework 4 #3a
- SELECT DATEPART(weekday, p.CreationDate), COUNT(*) FROM P...
- DECLARE @TwoMonthsAgo DATE = DATEADD(month, -2, GETUTCDAT...
- WITH NiceAnswerBadges AS (SELECT * FROM Badges WHERE Name...
- SELECT Id FROM Tags WHERE TagName = '##tagname##'
- Top 10 question askers in 'windows-8' tag in the last 30 days
- Top tags last month