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.
Preguntas de entrevista [1]
Pregunta 1
What is DI and how can I use it in order to improve my services.
Solicité el puesto a través de un captador. El proceso duró 2 semanas. Acudí a una entrevista en 10bis (Tel Aviv) en ene 2020
Entrevista
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
Preguntas de entrevista [1]
Pregunta 1
a little system consisting of an SQL SP(nested JOINs, multiple tables), and a microservice to retrieve it