I have a table called "client_job" and a column called "dollar amount"
I want to get the sum of the column "dollar_amount" with few parameters.
How do I write a statement that says
column_c (SELECT SUM(dollar_amount) AS gross_income WHERE remittance_date > curdate())
This is one of the variations I tried.
SELECT client_job.job_id, client_job.url_id, SELECT SUM(dollar_amount) as gross_income FROM client_job WHERE client_job.remittance_date > curdate() GROUP BY job_id, FROM client_job