Powershell 3 Cmdlets | Hackerrank Solution
$avgSalary = $grouped.Group | Measure-Object Salary -Average Creates new columns on-the-fly.
$data | Where-Object $_.YearsOfExperience -ge 2 Sorts by one or more properties. powershell 3 cmdlets hackerrank solution
Department AverageSalary ---------- ------------- Finance 100000 IT 85000 The challenge will silently test you on: Case 1: Fewer than 3 eligible employees If only 2 employees have >=2 years experience, your Select-Object -First 3 will return just 2, and Group-Object still works fine. Case 2: One department with multiple top earners If all top 3 are from IT, grouping will show only one row for IT with average salary of those 3. Case 3: Empty dataset If no employee has >=2 years experience, Where-Object outputs $null , and the rest of the pipeline should fail gracefully. HackerRank expects: $avgSalary = $grouped
$grouped = $top3 | Group-Object Department Calculates sum, average, min, max. Case 2: One department with multiple top earners