title

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

SELECT 
U.Location, COUNT (*)

 
FROM Posts as P
JOIN 
Users as U ON P.OwnerUserId =U.Id

WHERE
P.PostTypeId=1 AND P.Tags LIKE '%python%' AND P.CreationDate
BETWEEN'04-04-2017' and '04-03-2018'

GROUP BY U.Location
order by COUNT(*) DESC

Enter Parameters

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