support@chatgptassignment.com
######### Must have familiarity with the platform Retool (IDE) and be a PostgreSQL expert ############https://retool.com/###########https://www.postgresql.org/##########
Objective:
-Troubleshoot and optimize an existing PostgreSQL table within the Retool integrated development environment (IDE).
-You will be provided temporary guest credentials for retool login and password after being selected as a tutor
-You will be provided with the original database schemas, tables, and the updated ones that need to be deployed with minor syntax error fixes after being selected as a tutor
-Instructions on how to get to the table, schemas, and queries after being selected as a tutor
-Provide detailed explanations, annotations, and screenshots of the issues being fixed within the table.
-Listed below is a detailed list of all the issues that need to be resolved
Issues:
-Unpaid Invoices are showing up as fully paid by a credit memo even if the credit memo is only covers part of the invoice (example: Invoice 67849)
-invoices that have been fully paid by credit memo should be automatically marked as paid in retool (example: Invoice 67272)
-Invoices paid from bank deposits in Quickbooks are not being calculated correctly (example: Invoice 66937)