Pandas and Numpy Gold Badge Holders

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

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 = 'biopython'
   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 = 'bioinformatics'
   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

Enter Parameters

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