Fetch top 3 departments along with their name and average monthly salary. Below is the format of the report. |DEPT_NAME|AVG_MONTHLY_SALARY (USD)|
Checkout the Website Input Data
In the attachment above, use each worksheet as a table in a relational database and write an SQL query that generates the output report
With the same attachment, use each worksheet as a CSV file and write a script (Bash or Python) that generates the same report. Data is to be read from the CSV files not from a database.
Given below is a Bash / Python script that performs following computation on an integer input (n): If n is less than 10: Calculate its Square Example: 4 => 16 If n is between 10 and 20: Calculate the factorial of (n-10) Example: 15 => 120 If n is greater than 20: Calculate the sum of all integers between 1 and (n-20) Example: 25 => 15