Database Reference
In-Depth Information
| clamours | 1284.1910566741906 |
| falchion | 1027.3528453393526 |
| swinged | 1027.3528453393526 |
| strucken | 898.9337396719336 |
| bewray | 898.9337396719335 |
| wooers | 898.9337396719335 |
| cozen | 770.5146340045145 |
| fitly | 770.5146340045145 |
…
| tapster | 770.5146340045144 |
…
| spritely | 642.0955283370954 |
…
Query #5: Table Unions
SELECT shakespeare.word AS word,
(shakespeare.word_count / english.freq) AS rel_freq,
FROM (
SELECT LOWER(word) AS word, SUM(word_count) AS
word_count
FROM [publicdata:samples.shakespeare]
WHERE NOT REGEXP_MATCH(word, '[A-Z]+')
AND NOT word CONTAINS "'"
GROUP BY word
) AS shakespeare
JOIN (
SELECT word, SUM(freq) AS freq
FROM (
SELECT LOWER(word) AS word, FLOAT(count) AS freq
FROM [bigquery-e2e:reference.word_frequency]
), (
SELECT LOWER(first) AS word, sum(cell.match_count)/
1583 AS freq
FROM [publicdata:samples.trigrams]
GROUP BY word)
GROUP BY word
) AS english
ON shakespeare.word = english.word
