print a special column in table

Question

Given this table:

Employee
--
firstname    
lastname
salary
age

I want to print the first name if it's started by "a" also i want to print the name of employee who has a salary more than 200$ and less than 1000$.

Answer 1

Here how you can implement your first requirement:

awk '{ if ($1 ~ /^a/) print $1; }' <file name>

Second one, salary, can be done in the same manner by adding additional if clause