Users_Extract

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

-- Q1
--Select count(Id) As [Number Of Users]
--From Users

-- Q2
/*SELECT AVG(Age) As [Average Age], COUNT(Id) As [Number Of Users]
FROM Users
GROUP BY Age*/

/*SELECT COUNT(p.Id) AS [Posts], pt.Name, u.DisplayName  
FROM Posts p
  INNER JOIN Users u
  ON p.OwnerUserId = u.Id
  INNER JOIN PostTypes pt
  ON pt.Id = p.PostTypeId
WHERE u.DisplayName = 'Mat Mannion'
AND pt.Name = 'Question'
GROUP BY  pt.Name, u.DisplayName */


--SELECT  Name 
--FROM PostTypes
--WHERE Name = 'Question'

SELECT TOP 1 u.DisplayName
FROM Users u
WHERE u.location = 'South Africa'

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results