Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a) Consider the following file called salaries.csv: uid, loc, div, year, sal dgarcia, WDC, fin, 2018, 102900 ejones, SEA, sales, 2017, 56450 3 dlarkin, RCH,

image text in transcribed

a) Consider the following file called salaries.csv: uid, loc, div, year, sal dgarcia, WDC, fin, 2018, 102900 ejones, SEA, sales, 2017, 56450 3 dlarkin, RCH, rsrch, 2019,78435 ccartwright, RCH, acct, 2019,48775 mlesko, OTT, rsrch, 2018,93870 criggs, WDC, sales, 2019, 62334 jpetrovski, RCH, acct 2017,68348 tchepregi, SEA, rsrch, 2018, 84290 amurchin, OTT, sales, 2019, 49038 gcarlson, RCH, fin, 2019, 70000 swelsh,wDC, sales, 2017,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 2019 . 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 2019 who earned a salary of $50,000 or more. You may write the gawk command-line in the space provided below and ensure that this Word document (with your solutions) is submitted to Canvas

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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