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.
Questions d'entretien [1]
Question 1
What is DI and how can I use it in order to improve my services.
J'ai postulé via un recruteur. Le processus a pris 2 semaines. J'ai passé un entretien chez 10bis (Tel Aviv-Yafo) en janv. 2020
Entretien
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
Questions d'entretien [1]
Question 1
a little system consisting of an SQL SP(nested JOINs, multiple tables), and a microservice to retrieve it