Myers Briggs Personality Tags on Reddit Data

This data was pulled on 11/10/2018 from google big query using the following query:

SELECT  flair_text.author_flair_text as flair_text, comments.body as body, comments.subreddit as subreddit, comments.author as author FROM
  (
  SELECT author,author_flair_text
  FROM [fh-bigquery:reddit_comments.all] 
  WHERE author_flair_text != 'null'
  AND REGEXP_MATCH(author_flair_text,r'([IEie][SNsn][TFtf][JPjp]\W)')
  GROUP BY author,author_flair_text
  ) AS flair_text
INNER JOIN
  (
  SELECT  author_flair_text, body, subreddit, author
  FROM [fh-bigquery:reddit_comments.all] 
  ) AS comments
ON
comments.author = flair_text.author