0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of poker

WITH pd AS (
  SELECT ROW_NUMBER() OVER (ORDER BY b.Date) AS pd_rank 
        , u.displayname AS pd_user, u.reputation AS pd_rep
        , b.Name AS pd_tag, b.Date AS pd_date
  FROM badges b
  INNER JOIN users u 
   ON b.userid = u.id
   AND b.name = 'swift'
   AND b.class = 1
), np AS (
  SELECT ROW_NUMBER() OVER (ORDER BY b.Date) AS np_rank 
        , u.displayname AS np_user, u.reputation AS np_rep
        , b.Name AS np_tag, b.Date AS np_date
  FROM badges b
  INNER JOIN users u 
   ON b.userid = u.id
   AND b.name = 'macos'
   AND b.class = 1
)
  
SELECT pd.*, np.*
FROM pd
FULL OUTER JOIN np
  ON pd.pd_rank = np.np_rank
ORDER BY pd.pd_Date

fork query

edited sep 18 20 anonymous

created sep 15 20 ParfaitG