Table of Contents

AI - LLM - Language

Flag each word as noun, verb, adjective, or adverb.

Consider this:


Nouns

A noun is a word that names something, such as a person, place, thing, or idea.

One important distinction to be made is whether a noun is a proper noun or a common noun. A proper noun is a specific name of a person, place, or thing and is always capitalized.


Verbs

Verbs are words that describe actions, whether physical or mental.


Adjective

An adjective is a word that describes the traits, qualities, or number of a noun.

An adjective is a word that describes or defines a noun or noun phrase.

Adjectives can modify nouns even without appearing right before them in a sentence.

Adjectives come in three forms, known as degrees: absolute, comparative, and superlative.


Adverb

An adverb is a word that modifies (describes) a verb, an adjective, another adverb, or even a whole sentence.


SELECT RANK() OVER(ORDER BY COUNT DESC) rank, COUNT, comment, avg_score, count_subs, count_authors, example_id 
FROM (
  SELECT comment, COUNT(*) COUNT, AVG(avg_score) avg_score, COUNT(UNIQUE(subs)) count_subs, COUNT(UNIQUE(author)) count_authors, FIRST(example_id) example_id
  FROM (
    SELECT body comment, author, AVG(score) avg_score, UNIQUE(subreddit) subs, FIRST('http://reddit.com/r/'+subreddit+'/comments/'+REGEXP_REPLACE(link_id, 't[0-9]_','')+'/c/'+id) example_id
    FROM [fh-bigquery:reddit_comments.2015_05]
    WHERE author NOT IN (SELECT author FROM [fh-bigquery:reddit_comments.bots_201505])
    AND subreddit IN (SELECT subreddit FROM [fh-bigquery:reddit_comments.subr_rank_201505] WHERE authors>10000)
    GROUP EACH BY 1, 2
  )
  GROUP EACH BY 1
  ORDER BY 2 DESC
  LIMIT 300
)