Differences

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

--- ai:llm:language [2024/11/29 12:25] – peter
+++ ai:llm:language [2024/11/30 10:35] (current) – peter
@@ Line 17: / Line 17: @@
   * Verb
+  * Nouns
+  * Pronouns
+  * Verbs
+  * Adjectives
+  * Adverbs
+  * Prepositions
+  * Conjunctions
+  * Interjections
 ----
@@ Line 78: / Line 86: @@
   * 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>
+----