Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following file called salaries.csv. uid.loc,div,vear,sal dgarcia, WDC, fin, 2017,102900 ejones, SEA, sales,2016,56450 dlarkin,RCH,rsr ch, 2018,78435 cartwright,RCH, acct, 2018, 48775 mlesko,OTT, rsrch, 2017,93870 criggs,WDC,

image text in transcribed

Consider the following file called salaries.csv. uid.loc,div,vear,sal dgarcia, WDC, fin, 2017,102900 ejones, SEA, sales,2016,56450 dlarkin,RCH,rsr ch, 2018,78435 cartwright,RCH, acct, 2018, 48775 mlesko,OTT, rsrch, 2017,93870 criggs,WDC, sales,2018,62334 ipetrovski,RCH, acct, 2016, 68348 tchepregi,SEA, rsrch, 2017,84290 amurchin,OTT, sales, 2018,49038 acarlson,RCH, fin, 2018,70000 swelsh,WDC, sales, 2016, 39876 Each field in this file is separated by a comma and each record is separated by a newline character. For this file, you will write a one-line gawk command-line to filter records for employees who earn $50,000 or more in 2018. Specifically, you will print out only the userid (i.e., uid), location (i.e., loc), and salary (i.e., sal) for those employees working in 2018 who earned a salary of $50,000 or more. You may write

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

6. Explain the strengths of a dialectical approach.

Answered: 1 week ago

Question

2. Discuss the types of messages that are communicated nonverbally.

Answered: 1 week ago