Answered step by step
Verified Expert Solution
Question
1 Approved Answer
d.The name of every person and their occupation who lives in an area its population more than 100000. Q2(.40 points) Given the following relation schema:
d.The name of every person and their occupation who lives in an area its population more than 100000.
Q2(.40 points) Given the following relation schema: PERSON ( FullName, Address, ZipCode, Occupation, Income) AREA( ZipCode, Population, AverageIncome) Use the SQL to express the following queries using a minimum number of operations and tables: a. The name of every person who does not have an occupation. b. The name of every person and their address whose income more than the average income in their zip code area. | c. The name of every software engineer who has the highest income in their zip code areaStep 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