Differences

This shows you the differences between two versions of the page.

--- ai:llm:language [2024/11/29 12:22] – peter
+++ ai:llm:language [2024/11/30 10:35] (current) – peter
@@ Line 5: / Line 5: @@
   * Commonly, Adjectives modify nouns and Adverbs modify verbs.
+Consider this:
+  * Adjective
+  * Adverb
+  * Conjunction
+  * Determiner
+  * Noun
+  * Number
+  * Preposition
+  * Pronoun
+  * Verb
+  * Nouns
+  * Pronouns
+  * Verbs
+  * Adjectives
+  * Adverbs
+  * Prepositions
+  * Conjunctions
+  * Interjections
 ----
@@ Line 64: / Line 84: @@
 An adverb is a word that modifies (describes) a verb, an adjective, another adverb, or even a whole sentence.
-  Adverbs often end in -ly, but some (such as fast) look exactly the same as their adjective counterparts.
+  * Adverbs often end in **-ly**, but some (such as fast) look exactly the same as their adjective counterparts.
+----
+<code sql>
+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
+)
+</code>
+----