Retool. PostgreSQL, and schema issues

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. Word Document preference, please show screenshot snippets of code before and after changes are made with detailed explanations

-Listed below is a detailed list of all the issues that need to be resolved

Issues:

Issue #1: Mark Invoice 72681 as unpaid in retool

Issue #2: Duplicate issue for customers specially on the SALES and INVOICES Page in retool:

Issue #3: Update names

• Landscape Contractor -> Contractor – Landscape
• Lighting & Interior Designers -> Lighting & Interior Designers
• E-commerce Distributors -> E-Commerce Distributor

Issue #4: Add company industries (under the customers section)

New additions are:

• Multifamily
• Commercial
• Contractor – Other
• Contractor – Electrical
• Contractor – Audio Visual (AV)

Distributor – Other