Database Reference
In-Depth Information
number of total occurrences. It also includes a count of how many plays
use the word and the total number of times the word is used across all
Shakespeare's plays. The top results are displayed here:
+----------+---------+-------+
| word | corpora | total |
+----------+---------+-------+
| should | 42 | 1505 |
| heaven | 42 | 585 |
| myself | 42 | 564 |
| himself | 42 | 471 |
| though | 42 | 445 |
| tongue | 42 | 436 |
| thought | 42 | 400 |
| thousand | 42 | 343 |
| things | 42 | 321 |
| without | 42 | 301 |
| reason | 42 | 290 |
| cannot | 41 | 745 |
| before | 41 | 658 |
| honour | 41 | 641 |
| better | 41 | 587 |
| nothing | 41 | 567 |
| little | 41 | 503 |
| friends | 41 | 480 |
| friend | 41 | 440 |
| indeed | 41 | 369 |
+----------+---------+-------+
The top result is “should,” appearing a total of 1,505 times in all 42 corpora.
Perhaps this means that Shakespeare enjoyed telling people what to do.
The
SELECT
statement, at first, doesn't look too different from query #1.
You now have
SELECT word, COUNT(*) AS corpora,
SUM(word_count) AS total
instead of
SELECT LOWER(word) AS
word, word_count as frequency, corpus
.
However, the operations performed by these two lines are different; the
key is in the functions that are called. In Query #1, the function called in
the
SELECT
statement was
LOWER()
, which translates the field value to
