Question: List instructor id, instructor last name, instructor first name, course name, and course number that instrucotor id in instructors is the same as instructor id
- List instructor id, instructor last name, instructor first name, course name, and course number that instrucotor id in instructors is the same as instructor id in courses. Save it as Q1
- From the instructor table, if 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 Q2
- From the instructor table, if instructors 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 Q3
- From the instructor table, if instructors last name is one of chandar, kamiar, jurewics, or wong and salary is greater than 8000, print it very rich, along with last name, first name, and salary. Otherwise print it rich. Save it as Q4
- From the kingcounty table, count how many homes were built each year. Name it as homeCount. Save it as Q5
- From the kingcounty table, display count of homes built each year. If count is greater than 10, then print more than 10. Otherwise print less than 10. Give an alias to the new field as about10. Save it as Q6
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
