Frage im Vorstellungsgespräch bei Target

SQL Questions: Aggregation Query: Given an Employees table with a Department column and other relevant attributes, write a query to calculate the average salary for each department, excluding employees who earn ₹50,000 or more.