Time Sensitive Basic Linux Shell Scripting Focusing on sed

[Time Sensitive] Basic Linux Shell Scripting ( Focusing on sed & awk )

A file has three columns. In column-1 the name of employee and in column-2 he salary of employee is given. Write the line to display the name of employees that make more than 50000.

Solution

Please try with the following query:

SELECT employee_name FROM table_name WHERE employee_salary > 50000;

Thank you.