Ho presentato la mia candidatura online. La procedura ha richiesto 3 giorni. Ho sostenuto un colloquio presso Neoquant Solutions (Mumbai) nel mese di gen 2025
Colloquio
The posted questions are of round two. Round 1 is technical but everything verbal. Round two involves query solving of which two questions are posted below. Overall it was a good experince,
Domande di colloquio [2]
Domanda 1
You manage a retail database that includes Customers, Orders, and OrderDetails tables.
Question: Find the top 5 customers who have spent the most on orders in the last year.
Details
Columns:
Customers: CustomerID, CustomerName
Orders: OrderID, CustomerID, OrderDate
OrderDetails: OrderID, ProductID, Quantity, Price
you have an Attendance table tracking employee attendance, including EmployeeID, Date,
and Status (e.g., "Present", "Absent", "On Leave").
Question: List employees who have been absent for more than 5 days in the last month.
Details:
Attendance: EmployeeID, Date, Status
