5- write a query that produces the following for eachemployee: <employee last na
ID: 3609920 • Letter: 5
Question
5- write a query that produces the following for eachemployee:
<employee last name> earns <salary> monthly butwants <3 times salary>
Label the column dream salaries.
Dream Salaries
King earns $24,000.00 monthly but wants $72,000,00
Kochar earns $17,000,00 monthly but wants $51,000,00
6- create a query to display the last_name and salary for allemployees.
Format the salary to be 15 characters long, left-paddedwith.
Label the column SALARY.
LAST-NAME
SALARY
King
$$$$$$$$$$24000
Kochar
$$$$$$$$$$17000
Dream Salaries
King earns $24,000.00 monthly but wants $72,000,00
Kochar earns $17,000,00 monthly but wants $51,000,00
Explanation / Answer
Dear.., <employee last name> earns <salary> monthly butwants <3 times salary> Label the column dream salaries. Dream Salaries King earns $24,000.00 monthly but wants $72,000,00 Kochar earns $17,000,00 monthly but wants $51,000,00 SELECT last_name ||'earns'|| TO_CHAR(salary,'fm$99,999')||'monthly but wants'||TO_CHAR(salary*3,'fm$99,999')||'.' "Dream salaries" FROMemployree You try for remaining one. you want any clarificationcramster is there. You try for remaining one. you want any clarificationcramster is there.Dream Salaries King earns $24,000.00 monthly but wants $72,000,00 Kochar earns $17,000,00 monthly but wants $51,000,00
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.