 |
 |
How might I write an SQL query to find all the descriptions of good kings and bad kings in my database? I have a table that looks something like this: key word part_of_speech position --- --------- -------------- -------- w1 The article 1 w2 righteous adjective 2 w3 king noun 3 w4 solved verb 4 w5 all adjective 5 w6 the article 6 w7 problems noun 7 w8 Your noun 8 w9 evil adjective 9 w10 king noun 10 w11 over adverb 11 w12 taxes verb 12 w13 us pronoun 13 And I want to list how kings are described. In this example, kings are both righteous as well as evil. How can I implement this in pure SQL? How do I find all words where the given word is "king" and the previous word is an adjective? — Eric Morgan