SQL database: Write your query to retrieve data from the table.

Link to get the databse: https://drive.google.com/file/d/0B0kVn308bqFuVV9PZXQxZDF1ME0/view?usp=sharing

a. show all columns for the people with a usid between 100 and 120 (inclusive)

b. show the workclass and education of people under 20

c. show all columns for people over 80 select * from census where age>80 limit 10;

d. show the age, sex, years of education, and capital gains of people with capital gains > 10000

e. show the sex, age, and marital status for people in the armed forces

f. show the number of years of education for people over 50 years old in the armed forces

g. show all columns for 17 year olds with less than 5 years of education

h. show the occupation of women under the age of 40 with a Doctorate degree

i. show all columns for people under the age of 21 with a Masters degree

j.show the age of females with either a bachelors or a masters degree