I need Sql Developer to help review and update a query

Job ID: 34811592

Budget: $30 – $250 USD

so there are 3 major goals here
1. Is to reducethe number of queries to one table
2. Is to ensure accurate data is pulling from the tables through ETL
3. Update the query if it's not pulling correctly