4. Using a WITH clause write a SELECT statement to list the job_title of those jobs whose maximum salary is more than half the maximum salary of the entire company. Name your subquery MAX_CALC_SAL. Name the columns in the result JOB_TITLE and JOB_TOTAL, and sort the result on JOB_TOTAL in descending order.
Hint: Examine the jobs table. You will need to join JOBS and EMPLOYEES to display the job_title.
Recently Asked Questions
- can you please tell me the correct answers to these questions P-1-5 A-D
- The English interpretation of colonization presented a picture of a "kinder and gentlercolonist" than the Spanish model. Explain whether you agree or disagree
- The answer must be a minimum of 1-full page in length with a minimum of 2 - outside source. Please be sure to follow APA guidelines for citing and referencing