I have a SQL query that is querying data from DB. The situation is pretty much a described here: https://stackoverflow.com/questions/50477988/unable-to-group-by-a-single-field-when-multiple-fields-appear-in-the-select-clau
Right now, I have some logic in SQL and some logic in Java. The Java logic is pretty simple inside Java. But I am strugging to bring that inside SQL.
Your goal is to make a SQL query that is optimized and get rid of the Java piece. I have a SQL DB with data that you could use remotely.
Project Type: One-time project