Database SQL questions:

You can download the table from this link:

https://drive.google.com/file/d/0B0kVn308bqFuZkFULTBSU1lzdEk/view?usp=sharing

1) How long will it take to perform a linear search of a database table that is stored in 10 000 disk blocks? Each block is 4000 bytes, the disk access time is 10 ms, and the disk transfer time is 100 MB/sec. (Give you answer in milliseconds (ms).)

2) How many contributions were made from contributors with an occupation that contains the string CEO? Output a single number.

3) Show, for each zip that appears in the contributor table, the number of contributions greater than $ 2000. Every zip in the contributor table should appear in the query result, even if there are no contributions > $2000 for that zip.