Given 2 tables EMPLOYEE and EVALUATION, query for the count of names whose Rating is less than 3. Also, query for the count of names whose Rating is greater than 8.
The description of the tables are given below:
EMPLOYEE:
EVALUATION:
NOTE : The output should first give the count of names whose rating is less than 3 and than the count of names whose rating is greater than 8.
Example :
Count(Name)
5
Count(Name)
10
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
