1) I have been provided with an SQL Query like
2) I also could able to see the above tables present in the SQL Query with an universe connection(MSSQL) based schema user.
Now, i am struck with what universe design i can approach for eg: derived table with provided sql query or to design with table and joins of the SQL Query or to write an custom sql in the report level. Pls. provide some steps for the right approach.