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