text: CREATE TABLE PLAYERS(ID string, FIRSTNAME string, LASTNAME string, FIRSTSEASON int, LASTSEASON int, WEIGHT int, BIRTHDATE date);
  
  SELECT P1_FIRSTNAME, P1_LASTNAME, 
         P2_FIRSTNAME, P2_LASTNAME 
  FROM (
    SELECT P1.FIRSTNAME AS P1_FIRSTNAME, P1.LASTNAME AS P1_LASTNAME,
           P2.FIRSTNAME AS P2_FIRSTNAME, P2.LASTNAME AS P2_LASTNAME,
           P1.FIRSTSEASON AS P1_FIRSTSEASON, P1.LASTSEASON AS P1_LASTSEASON,
           P2.FIRSTSEASON AS P2_FIRSTSEASON, P2.LASTSEASON AS P2_LASTSEASON
      FROM PLAYERS P1, PLAYERS P2 
    WHERE P1.ID<>P2.ID
    ) SUB_Q 
  WHERE P1_FIRSTSEASON<P2_FIRSTSEASON 
    AND P1_LASTSEASON>P2_LASTSEASON;
  