I have a plain 10 lines sql query fetching data from ony two tables and have only 1 join. This query is working fine.
I want to modify the query to return 4 new columns. Refer screenshot.
I will provide the sql query and backup file . Or you directly fix the query on my machine by taking control of my screen.