- there is no validation because i don't know the input constrains
- there is no crud operation because it's not part of the task
- this query also can be improved by adding caching(like radis) and pagination
- number of orders per customer : is assumed to be the count of orders per customer
- total amount of total orders by customer : is assumed to be the sum of the column called total amount for all orders per customer
devahmedradwan / search-task Goto Github PK
View Code? Open in Web Editor NEWsearch task