/*SELECT U.DisplayName, B.Name FROM Users AS U JOIN Badge...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

/*SELECT U.DisplayName, B.Name
FROM Users AS U JOIN Badges as B ON B.UserId = U.Id
WHERE U.Reputation > 1000;*/

SELECT
  (SELECT U.DisplayName
   FROM Users AS U
   WHERE U.Id = B.UserId AND U.Reputation > 1000
   ) AS DisplayName,
   B.Name
FROM Badges AS B
/*WHERE EXISTS (SELECT U.Id
              FROM Users AS U
              WHERE U.Id = B.UserId AND U.Reputation > 1000)*/
ORDER BY B.Date

/*SELECT
(SELECT U.DisplayName
 FROM Users AS U
 WHERE U.Id = B.UserId AND U.Reputation > 1000)
 FROM Badges as B
 WHERE*/

  
/*SELECT U.DisplayName, U.test
FROM USers U
WHERE U.Reputation > 1000 AND U.test = (SELECT B.NAME
                                      FROM Badges AS B
                                      WHERE B.UserId = U.Id);*/
/*SELECT
  (SELECT U.DisplayName
   FROM Users AS U
   WHERE U.Id = B.UserId AND U.Reputation > 1000
   ) AS DisplayName
FROM Badges AS B
WHERE EXISTS DisplayName
ORDER BY B.Date*/

Enter Parameters

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