$1.$ From the instructor table, list instructor ID$,$ instructor last name, instructor first name, course name, and course number The instructor ID in instructors is the same as the instructor ID in courses. Save it as Q$1$

$2.$ From the instructor table, if the instructor is paid greater than $6,000,$ print it $$expensive professor$$ along with last name, first name, department, and salary. Otherwise, print it $$not expensive$.$ Save it as Q$2$

$3.$ From the instructor table, if the instructor$$s last name is one of chandar, kamiar, jurewicz, or wong, print it $$ rich people$,$ along with last name, first name, and salary. Otherwise, print it $$not rich$.$ Save it as Q$3$

$4.$ From the instructor table, if the instructor$$s last name is one of chandar, kamiar, jurewics, or wong and the salary is greater than $8000,$ print it $$ very rich$,$ along with last name, first name, and salary. Otherwise, print it $$rich$.$ Save it as Q$4$

$5.$ From the kingcounty table, count how many homes were built each year. Name it as homeCount. Save it as Q$5$

$6.$ From the kingcounty table, display the count of homes built each year. If the count is greater than $10,$ then print $$more than $10.$ Otherwise, print $$less than $10.$ Give an alias to the new field as $$about$10.$ Save it as Q$6$