Create SQL query with joins and aggregations and then create repository, service and, api.
The db is SQL server.
The code is .NET framework 4.7.2.
In the end you need to tell pros and cons of your implementation.
Domande di colloquio [1]
Domanda 1
What is DI and how can I use it in order to improve my services.
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso 10bis (Tel Aviv) nel mese di gen 2020
Colloquio
a phone call from the hr asking about my professional background, then a face to face interview with the group leader, then an on-site assignment of 2 hours, and then discussing the assignment
Domande di colloquio [1]
Domanda 1
a little system consisting of an SQL SP(nested JOINs, multiple tables), and a microservice to retrieve it