Given 2 tables ENGINEER and DATA, query for the total count of each Type in the ENGINEER table. Print the result in alphabetical order of the Type.
Note: The ID columns in both tables are identical.
The description of the 2 tables are given below:
ENGINEER:
DATA:
‘ID’ in DATA table is identical to ‘ID’ in ENGINEER table
NOTE : The output should contain 1 columns by the name ‘A’. The output should be Sorted by Type .
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.