Accenture .NET Full Stack Developer interview questions

1st round technical round .. ref out, mvc,webapi valuetype vs ref type. DI Write a stored procedure in SQL Server that accepts a department name as input and returns the list of employees (EmployeeId, Name, Salary) who belong to that department and have a salary greater than the department’s average salary. Write a query to fetch the top 5 customers by total purchase amount from Orders table. Table: Order Columns: CustId, OrderId, Amount