Assignment title: Information


Create a table wordlist id: number, and primary key entry: string. max length 50 definition: string. max length 200 Problem 2 Create a sequence seq id. it starts with 1000, and increments by 1. Problem 3 Execute the query script InsertWords.sql. When the InsertWord.sql is completed, execute "SELECT count(*) from worldlist". It should return 109609. If "InsertWords.sql" fails, check your table description. If your table and sequence are created correctly, "InsertWords.sql" should work. Dont forget to execute commit. Problem 4 What is the word with maximum length? Write the SQL statement to find that word. Problem 5 List 15 longest words and their lengths. Write the SQL statement. answer: ...... 23 disestablismentarianism 23 electroencephalographic 22 counterclassifications 5 ........ Problem 6 Count the words that start with letter "s". Write the SQL statement. Problem 7 Count the words that start with letter "a" or letter "b". Write the SQL statement. Problem 8 List all words that contain "decima". Write the SQL statement Problem 9 List all words that contain "epp" and length is smaller than 8. For example: "pepper" Page 2 of 4Anwar Mamat CMP 556 (Anwar 11:59pm): Assignment #1 Problem 9 Problem 10 What is the average length of all words that start with the letter t? Write the SQL statement. Problem 11 For each letter in alphabet, count the words that start with that letter. Write SQL statement example: letter count ..... a some number b some number 5 ....... s 12108 ...... Problem 12 Count the number of words, in which "w" is the 5th letter. For example: "homework" Problem 13 Fill in the definition for the word "universal". Write the SQL Statement. Problem 14 Which letter has the minimum number of words that end with that letter? Write the SQL statement. F