HW1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

/*SELECT CONVERT(VARCHAR(7),CreationDate,120) AS 'year-month', COUNT(*) AS 'count' FROM Posts
GROUP BY CONVERT(VARCHAR(7),CreationDate,120)
ORDER BY CONVERT(VARCHAR(7),CreationDate,120);

SELECT CONVERT(VARCHAR(4),CreationDate,120) AS 'year', CONVERT(VARCHAR(2),CreationDate,110) AS 'month', PostTypeId, 
count(*) AS 'count'FROM Posts
GROUP BY CONVERT(VARCHAR(4),CreationDate,120), CONVERT(VARCHAR(2),CreationDate,110), PostTypeId
ORDER BY count(*) DESC;

SELECT Name AS 'name',count(UserId) AS 'cnt' FROM Badges
GROUP BY Name
HAVING count(UserId)>=20
ORDER BY count(UserId) DESC;
*/

SELECT Id, DisplayName,Location FROM Users
WHERE Location LIKE '%NY%' or Location LIKE '%New York%';

SELECT Id, DisplayName,Location FROM Users
WHERE Location LIKE '%New York City%';

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results