Given 2 tables EMPLOYEE and EVALUATION, build a report containing the 2 columns, Name and Rating. Employees with Ratings less than 6 should appear as NULL in the table. The entries in the table should be sorted by descending order of Rating, followed by Names in lexicographic order.
The description of the tables are given below:
EMPLOYEE:
EVALUATION:
NOTE : The output should contain 2 columns by the name ‘Names’ and ‘Rating’.
Example :
NOTE: You only need to implement the given function. Do not read input, instead use the arguments to the function. Do not print the output, instead return values as specified. Still have a question? Checkout Sample Codes for more details.
1 Million +
Strong Tech Community500 +
Questions to Practice100 +
Expert Interview Guides
