2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

/* http://stackoverflow.com/teams/68/metova */

CREATE TABLE #MetovaUsers (Name nvarchar(100), StackOverflowUserId int)

INSERT INTO #MetovaUsers (Name, StackOverflowUserId)
SELECT 'Andrew Markley', 5683335 UNION
SELECT 'Beverly Massengill', 5016590 UNION
SELECT 'Bo Malone', 6199784 UNION
SELECT 'Brennan Willingham', 6109563 UNION
SELECT 'Bryan Lindsey', 5630906 UNION
SELECT 'Chris Dillard', 6257596 UNION
SELECT 'David Jones', 6199628 UNION
SELECT 'David Knapp', 5630998 UNION
SELECT 'Drew Hamilton', 6194604 UNION
SELECT 'Emmy DeLoach', 4735818 UNION
SELECT 'Jami Couch', 2473275 UNION
SELECT 'Jason Ellis', 2937885 UNION
SELECT 'Justin Pulliam', 6199644 UNION
SELECT 'Kaleb Lape', 5631086 UNION
SELECT 'Kurt Treangen', 812828 UNION
SELECT 'Lee Dykes', 2608412 UNION
SELECT 'Logan Gauthier', 4431666 UNION 
SELECT 'Logan Serman', 29595 UNION 
SELECT 'Michael Eatherly', 843766 UNION
SELECT 'Michelle Heyyyyy', 2055457 UNION
SELECT 'Nicholas Craig', 5683606 UNION
SELECT 'Nick Griffith', 2792531 UNION 
SELECT 'Nick Sinas', 78550 UNION 
SELECT 'Renzo Rivas', 6199657 UNION
SELECT 'Riley Mills', 634997 UNION
SELECT 'Shahin Zangenehpour', 4727913 UNION
SELECT 'Skye McCaskey', 2687747 UNION
SELECT 'Victor Gong', 6199666 UNION
SELECT 'William Grand', 3362256

SELECT MU.Name, 

  -- STACK OVERFLOW --
  'http://stackoverflow.com/users/' + CAST(SOU.Id as nvarchar) + '|' + SOU.DisplayName AS SOUserName, 
  SOU.Reputation AS StackOverflowRep,
  SOU.CreationDate AS SOJoinDate,
  SOU.Reputation / DATEDIFF(WEEK,SOU.CreationDate,GETDATE()) AS [SO Rep/Week Average]

/*
  -- CODE REVIEW --
  'http://codereview.stackexchange.com/users/' + CAST(CRU.Id as nvarchar) + '|' + CRU.DisplayName AS CRUserName, 
  CRU.Reputation AS CodeReviewRep,
  CRU.CreationDate AS CRJoinDate,
  CRU.Reputation / DATEDIFF(WEEK,CRU.CreationDate,GETDATE()) AS [CR Rep/Week Average]
 */
 
/*
  -- PROGRAMMERS --
  'http://programmers.stackexchange.com/users/' + CAST(PU.Id as nvarchar) + '|' + PU.DisplayName AS ProgrammersUserName,
  PU.Reputation AS ProgrammersRep,
  PU.CreationDate AS ProgrammersJoinDate,
  PU.Reputation / DATEDIFF(WEEK,PU.CreationDate,GETDATE()) AS [Programmers Rep/Week Average]
 */
  
FROM #MetovaUsers MU
  LEFT OUTER JOIN StackOverflow.dbo.Users SOU ON SOU.Id = MU.StackOverflowUserId
--  LEFT OUTER JOIN [StackExchange.CodeReview].dbo.Users CRU ON CRU.AccountId = SOU.AccountId
--  LEFT OUTER JOIN [StackExchange.Programmers].dbo.Users PU ON PU.AccountID = SOU.AccountId
ORDER BY 
  ISNULL(SOU.Reputation,0)
  --+ISNULL(CRU.Reputation,0)
  --+ISNULL(PU.Reputation,0) 
  DESC, 
  SOJoinDate ASC

fork query

edited jan 26 18

created jun 8 15 nhgrif