Need a Laravel 7 Query with Sub query that has condition SUM payments

Job ID: 33732121

Budget: $15 – $25 USD

I do not have models for the sub query ..
You will use the existing query and add the subquery

Table is large joins and needs a SUM in the last column ..the sum is the subquery
..its a sum of payments that belong to a job that are joined to a parent table
Related categories: PHP Software Architecture MySQL HTML Laravel