SQL query to show what has been paid each month
- by Tommy Jakobsen
I'm looking for help to create a query, to solve the following problem:
Let's imagine the row:
Name StartDate EndDate Payed
James 10-10-2010 17-02-2011 860
And heres the schema for the table as requested:
payment_details (name VARCHAR(50) NOT NULL,
start_date DATETIME NOT NULL,
end_date…