Answered step by step
Verified Expert Solution
Question
1 Approved Answer
When asking about particular words give the id only. Using below dataset write SQL query for below asked questions: Which word from the vocabulary appears
When asking about particular words give the id only. Using below dataset write SQL query for below asked questions:
Which word from the vocabulary appears the most across all of the documents, in terms of total count?
How many documents have fewer than 50 words from the vocabulary?
What is the average number of total words per document?
What is the average number of distinct words per document?
DATASET:
| docID | wordID | count |
| 218018 | 16708 | 3 |
| 30030 | 82315 | 1 |
| 220346 | 38056 | 1 |
| 71397 | 101945 | 1 |
| 217079 | 29175 | 1 |
| 120404 | 32505 | 1 |
| 157818 | 3298 | 1 |
| 155989 | 38386 | 1 |
| 139381 | 34563 | 2 |
| 61337 | 38645 | 1 |
| 17912 | 15400 | 1 |
| 132474 | 30839 | 2 |
| 143698 | 6118 | 1 |
| 122907 | 45184 | 3 |
| 139125 | 44083 | 1 |
| 12536 | 98694 | 1 |
| 62769 | 40176 | 1 |
| 182243 | 31481 | 1 |
| 150117 | 22626 | 1 |
| 33072 | 7523 | 1 |
| 52784 | 42526 | 1 |
| 119630 | 43885 | 1 |
| 143362 | 21560 | 1 |
| 227158 | 16043 | 1 |
| 51832 | 97413 | 6 |
| 58853 | 15286 | 1 |
| 166299 | 54926 | 1 |
| 67365 | 31107 | 1 |
| 174389 | 31192 | 1 |
| 217952 | 3393 | 1 |
| 98207 | 8539 | 1 |
| 232970 | 25762 | 1 |
| 11775 | 5898 | 2 |
| 112472 | 13259 | 1 |
| 145323 | 31943 | 1 |
| 38469 | 9976 | 2 |
| 118762 | 8229 | 1 |
| 108917 | 22142 | 1 |
| 4790 | 77124 | 1 |
| 177448 | 15953 | 3 |
| 215038 | 8237 | 1 |
| 231600 | 229 | 2 |
| 145434 | 35560 | 2 |
| 41544 | 30592 | 1 |
| 84696 | 10342 | 1 |
| 168470 | 13183 | 1 |
| 133931 | 50953 | 1 |
| 207672 | 16367 | 1 |
| 168398 | 3585 | 1 |
| 186565 | 21784 | 1 |
| 82537 | 31081 | 3 |
| 193315 | 112 | 1 |
| 198652 | 14109 | 1 |
| 221427 | 903 | 2 |
| 216355 | 32557 | 1 |
| 120284 | 41174 | 1 |
| 82963 | 14312 | 1 |
| 193357 | 34700 | 1 |
| 97306 | 31807 | 1 |
| 117509 | 32292 | 1 |
| 125701 | 36679 | 4 |
| 120865 | 21695 | 1 |
| 168358 | 67508 | 2 |
| 153346 | 8180 | 1 |
| 172656 | 6065 | 1 |
| 198466 | 18337 | 1 |
| 216751 | 31643 | 1 |
| 73364 | 35853 | 1 |
| 207845 | 45273 | 1 |
| 134886 | 46286 | 1 |
| 23331 | 40144 | 2 |
| 82016 | 13965 | 1 |
| 154566 | 15524 | 1 |
| 205936 | 37799 | 1 |
| 219413 | 10287 | 1 |
| 102621 | 15306 | 3 |
| 10225 | 5867 | 1 |
| 170830 | 22522 | 1 |
| 23764 | 8 | 1 |
| 82623 | 18566 | 1 |
| 129414 | 21695 | 1 |
| 105121 | 8324 | 1 |
| 145083 | 5865 | 1 |
| 60071 | 29110 | 1 |
| 36080 | 19020 | 1 |
| 18952 | 24052 | 2 |
| 49381 | 32329 | 1 |
| 108741 | 24938 | 1 |
| 32175 | 15226 | 1 |
| 223136 | 6889 | 1 |
| 69650 | 25244 | 12 |
| 190523 | 28869 | 1 |
| 110230 | 10979 | 1 |
| 100508 | 12965 | 1 |
| 7402 | 6476 | 1 |
| 166273 | 35010 | 1 |
| 114859 | 32802 | 1 |
| 52901 | 31175 | 1 |
| 194549 | 20784 | 3 |
| 38189 | 31598 | 1 |
| 124085 | 81931 | 1 |
| 211890 | 28948 | 1 |
| 152558 | 18284 | 1 |
| 84279 | 30312 | 1 |
| 230466 | 35560 | 1 |
| 115463 | 34366 | 2 |
| 22965 | 33575 | 1 |
| 198591 | 7551 | 1 |
| 192171 | 5730 | 1 |
| 174497 | 31688 | 1 |
| 145980 | 38341 | 1 |
| 36813 | 6111 | 1 |
| 89678 | 38708 | 1 |
| 56403 | 32265 | 1 |
| 2254 | 4203 | 1 |
| 133369 | 29718 | 1 |
| 84440 | 37472 | 2 |
| 1152 | 90308 | 1 |
| 156514 | 14282 | 1 |
| 63211 | 3359 | 2 |
| 228016 | 4064 | 1 |
| 206483 | 30808 | 1 |
| 191552 | 45044 | 2 |
| 215139 | 96108 | 1 |
| 158366 | 30271 | 1 |
| 21923 | 34559 | 1 |
| 9409 | 1790 | 1 |
| 71344 | 2340 | 1 |
| 200382 | 34770 | 5 |
| 46305 | 34784 | 1 |
| 184825 | 8490 | 1 |
| 161377 | 38461 | 1 |
| 119540 | 91983 | 1 |
| 121445 | 33593 | 1 |
| 54206 | 13015 | 2 |
| 38674 | 19167 | 1 |
| 224735 | 62852 | 2 |
| 24197 | 11058 | 1 |
| 112532 | 20955 | 1 |
| 28426 | 32560 | 1 |
| 8447 | 2235 | 1 |
| 158138 | 30066 | 1 |
| 22156 | 7140 | 1 |
| 97854 | 13172 | 1 |
| 122225 | 33799 | 2 |
| 188508 | 21561 | 1 |
| 173450 | 10843 | 1 |
| 103251 | 38076 | 1 |
| 212124 | 47203 | 10 |
| 14480 | 23026 | 1 |
| 67477 | 21537 | 1 |
| 208056 | 15014 | 1 |
| 11366 | 27774 | 3 |
| 48982 | 22477 | 1 |
| 96771 | 10185 | 2 |
| 143018 | 15716 | 4 |
| 80333 | 30166 | 3 |
| 41640 | 6022 | 1 |
| 122880 | 15615 | 1 |
| 58679 | 26080 | 1 |
| 66537 | 13954 | 1 |
| 212023 | 30426 | 1 |
| 74803 | 30144 | 1 |
| 129421 | 30454 | 1 |
| 233003 | 3365 | 1 |
| 189617 | 40963 | 2 |
| 19495 | 806 | 2 |
| 103844 | 60877 | 1 |
| 172453 | 7170 | 1 |
| 61355 | 3198 | 1 |
| 45440 | 99156 | 2 |
| 54478 | 35185 | 1 |
| 178433 | 14110 | 1 |
| 214637 | 23068 | 1 |
| 47923 | 29719 | 1 |
| 91207 | 12074 | 1 |
| 58238 | 14240 | 1 |
| 135229 | 2599 | 1 |
| 92153 | 25772 | 1 |
| 4325 | 452 | 1 |
| 72270 | 13394 | 2 |
| 212206 | 31325 | 1 |
| 198406 | 28869 | 1 |
| 195134 | 26900 | 1 |
| 86554 | 38421 | 1 |
| 218237 | 40235 | 1 |
| 171015 | 9264 | 1 |
| 185575 | 4057 | 1 |
| 3889 | 21858 | 1 |
| 38680 | 98645 | 1 |
| 177083 | 32900 | 1 |
| 162823 | 26693 | 1 |
| 155367 | 39490 | 1 |
| 93473 | 30416 | 1 |
| 48087 | 13992 | 1 |
| 204086 | 39858 | 1 |
| 59721 | 22128 | 1 |
| 211695 | 34942 | 2 |
| 27604 | 39490 | 1 |
| 27601 | 11922 | 1 |
| 16183 | 41011 | 1 |
| 36674 | 96780 | 1 |
| 114351 | 33922 | 1 |
| 120689 | 6223 | 2 |
| 64106 | 13144 | 1 |
| 111332 | 36014 | 1 |
| 74234 | 35321 | 2 |
| 232246 | 29604 | 3 |
| 44677 | 40870 | 1 |
| 5962 | 23700 | 1 |
| 90085 | 8237 | 1 |
| 223639 | 40228 | 1 |
| 179826 | 8174 | 1 |
| 56839 | 13346 | 1 |
| 156178 | 5581 | 5 |
| 57029 | 3949 | 1 |
| 138399 | 33093 | 1 |
| 58347 | 12019 | 1 |
| 18853 | 20662 | 1 |
| 107858 | 24022 | 1 |
| 40423 | 25112 | 1 |
| 191040 | 3814 | 1 |
| 141726 | 36915 | 1 |
| 224975 | 38637 | 2 |
| 114637 | 29741 | 2 |
| 119212 | 35139 | 4 |
| 193303 | 12748 | 1 |
| 220571 | 25896 | 1 |
| 79645 | 4317 | 1 |
| 65574 | 258 | 1 |
| 96043 | 28073 | 2 |
| 148863 | 25815 | 1 |
| 66792 | 14929 | 1 |
| 58715 | 23667 | 1 |
| 24793 | 3949 | 2 |
| 181605 | 16852 | 2 |
| 218165 | 40363 | 1 |
| 125402 | 23158 | 1 |
| 41029 | 6085 | 2 |
| 168829 | 21330 | 1 |
| 36784 | 21205 | 1 |
| 137509 | 3356 | 2 |
| 207760 | 29534 | 1 |
| 154628 | 35169 | 1 |
| 12667 | 35686 | 1 |
| 170723 | 36153 | 1 |
| 68340 | 29346 | 1 |
| 109070 | 17820 | 2 |
| 206146 | 19603 | 1 |
| 133426 | 35493 | 1 |
| 1189 | 2668 | 1 |
| 98827 | 26611 | 1 |
| 73222 | 33545 | 1 |
| 174316 | 17325 | 1 |
| 223331 | 15989 | 1 |
| 121647 | 15618 | 1 |
| 214053 | 41050 | 1 |
| 39416 | 22177 | 1 |
| 86864 | 17712 | 2 |
| 137113 | 1464 | 3 |
| 189253 | 24052 | 4 |
| 18902 | 39018 | 1 |
| 125616 | 37555 | 1 |
| 89143 | 11844 | 1 |
| 176342 | 4382 | 1 |
| 66602 | 37702 | 1 |
| 204288 | 33461 | 1 |
| 192566 | 40383 | 1 |
| 88441 | 7770 | 1 |
| 69836 | 23204 | 2 |
| 127810 | 24461 | 1 |
| 135519 | 15718 | 1 |
| 231221 | 21797 | 1 |
| 189355 | 34463 | 2 |
| 205737 | 95996 | 1 |
| 137185 | 17362 | 1 |
| 90313 | 22867 | 1 |
| 109438 | 11027 | 4 |
| 122279 | 32705 | 1 |
| 33840 | 36749 | 1 |
| 188825 | 52471 | 1 |
| 211767 | 44110 | 1 |
| 184269 | 18201 | 1 |
| 177779 | 37423 | 1 |
| 168035 | 11884 | 1 |
| 149813 | 22537 | 1 |
| 31194 | 36987 | 1 |
| 126449 | 6384 | 1 |
| 162441 | 2470 | 2 |
| 157815 | 48806 | 16 |
| 226459 | 39866 | 1 |
| 102502 | 81538 | 17 |
| 60795 | 7297 | 1 |
| 47355 | 53856 | 2 |
| 157732 | 30087 | 7 |
| 48388 | 15256 | 1 |
| 162098 | 19768 | 1 |
| 65889 | 3572 | 1 |
| 45729 | 80960 | 1 |
| 26888 | 41175 | 1 |
| 91973 | 38809 | 1 |
| 133981 | 26066 | 1 |
| 212916 | 30261 | 1 |
| 201868 | 10474 | 2 |
| 158922 | 8668 | 2 |
| 167335 | 31426 | 1 |
| 187612 | 71140 | 3 |
| 15996 | 100306 | 2 |
| 89756 | 14655 | 2 |
| 148684 | 4640 | 1 |
| 49216 | 36344 | 1 |
| 191418 | 34366 | 1 |
| 87409 | 60777 | 1 |
| 14356 | 3141 | 1 |
| 56893 | 8959 | 1 |
| 221017 | 17024 | 1 |
| 147640 | 36385 | 1 |
| 224699 | 72461 | 1 |
| 230370 | 7633 | 5 |
| 65510 | 6412 | 1 |
| 101094 | 12549 | 1 |
| 147521 | 7321 | 1 |
| 128659 | 101965 | 1 |
| 113579 | 10913 | 1 |
| 223020 | 89269 | 5 |
| 50648 | 3088 | 2 |
| 12833 | 18774 | 1 |
| 218391 | 3187 | 1 |
| 88666 | 35693 | 1 |
| 42 | 62905 | 2 |
| 90805 | 6771 | 1 |
| 172690 | 8280 | 1 |
| 170568 | 16043 | 1 |
| 199689 | 17184 | 1 |
| 217820 | 24949 | 1 |
| 202906 | 36794 | 1 |
| 143179 | 91449 | 1 |
| 13422 | 28598 | 1 |
| 27207 | 2570 | 1 |
| 151680 | 12370 | 1 |
| 122607 | 10787 | 1 |
| 1442 | 7790 | 2 |
| 32871 | 69210 | 1 |
| 155235 | 15212 | 1 |
| 25477 | 33946 | 1 |
| 153568 | 8374 | 1 |
| 179021 | 39544 | 1 |
| 205749 | 78638 | 1 |
| 65763 | 11855 | 2 |
| 7102 | 17085 | 1 |
| 158126 | 8860 | 1 |
| 191059 | 38018 | 1 |
| 196423 | 76045 | 1 |
| 201322 | 2452 | 1 |
| 230063 | 14312 | 1 |
| 118424 | 14255 | 1 |
| 149690 | 27269 | 1 |
| 57876 | 460 | 6 |
| 45401 | 18528 | 1 |
| 7268 | 29788 | 1 |
| 127091 | 16040 | 1 |
| 81903 | 20752 | 1 |
| 220890 | 20631 | 2 |
| 77598 | 17792 | 1 |
| 144346 | 40362 | 1 |
| 197584 | 20841 | 2 |
| 167673 | 34366 | 1 |
| 85151 | 763 | 1 |
| 187621 | 36332 | 1 |
| 205406 | 3229 | 1 |
| 226909 | 35174 | 32 |
| 212161 | 6652 | 1 |
| 165060 | 31808 | 2 |
| 60730 | 84403 | 1 |
| 181715 | 26209 | 1 |
| 27140 | 21930 | 2 |
| 228687 | 25728 | 2 |
| 17870 | 17712 | 1 |
| 203047 | 7707 | 1 |
| 58091 | 34886 | 1 |
| 215133 | 34853 | 3 |
| 172487 | 35826 | 1 |
| 87267 | 6771 | 1 |
| 74945 | 23318 | 1 |
| 198030 | 15719 | 1 |
| 54930 | 13511 | 1 |
| 86382 | 34457 | 1 |
| 73645 | 83989 | 16 |
| 142687 | 95478 | 1 |
| 8363 | 4272 | 1 |
| 185720 | 35192 | 1 |
| 191139 | 24665 | 1 |
| 168660 | 11847 | 2 |
| 185870 | 31808 | 1 |
| 204339 | 8459 | 1 |
| 189374 | 20605 | 1 |
| 164367 | 20368 | 1 |
| 219460 | 10777 | 1 |
| 166184 | 22177 | 1 |
| 66136 | 1941 | 1 |
| 202285 | 35160 | 1 |
| 223382 | 57944 | 1 |
| 19303 | 96684 | 1 |
| 206316 | 31002 | 1 |
| 127064 | 43758 | 1 |
| 230523 | 22128 | 1 |
| 226153 | 88004 | 1 |
| 83976 | 2008 | 1 |
| 109042 | 18536 | 1 |
| 53973 | 27618 | 1 |
| 871 | 29560 | 1 |
| 29664 | 13907 | 3 |
| 37506 | 24385 | 2 |
| 88542 | 37413 | 1 |
| 221396 | 21205 | 1 |
| 78606 | 10787 | 1 |
| 138045 | 26934 | 1 |
| 204442 | 12315 | 1 |
| 1013 | 13174 | 1 |
| 91133 | 14368 | 1 |
| 140629 | 84208 | 3 |
| 8216 | 5210 | 1 |
| 91443 | 33166 | 1 |
| 157997 | 19677 | 1 |
| 34242 | 19768 | 1 |
| 220833 | 17629 | 1 |
| 2167 | 3356 | 1 |
| 26988 | 27911 | 9 |
| 151927 | 2342 | 2 |
| 33992 | 46159 | 1 |
| 126894 | 18811 | 1 |
| 84175 | 43525 | 1 |
| 5973 | 75711 | 1 |
| 129339 | 22839 | 1 |
| 23107 | 44340 | 1 |
| 134979 | 34376 | 1 |
| 79850 | 58000 | 3 |
| 92687 | 21024 | 1 |
| 178517 | 30292 | 1 |
| 130778 | 39930 | 1 |
| 139052 | 15625 | 1 |
| 31329 | 8093 | 1 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Concepts International Edition
Authors: David M. Kroenke
6th Edition International Edition
0133098222, 978-0133098228
