Sports

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT 
  u.Id, 
  u.DisplayName, 
  u.Views, 
  b.Name, 
  b.Class
FROM 
  Users u
JOIN 
  Badges b ON u.Id = b.UserId
WHERE 
  u.Views = (
    SELECT MAX(Views) 
    FROM Users 
    WHERE YEAR(CreationDate) = 2023
  )
AND 
  YEAR(u.CreationDate) = 2023;

Enter Parameters

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