This is probably the easiest query you'll ever have to write, but I'm not quite sure how to wrap my head around this yet. I know some basics with SQL, but haven't even modified a query in years. I'm hoping for help so I can digest how this type of a request would work and would love some insight. Based on the below data, I'm thinking the results will be $0, but would love to see a query to help me get a better grasp of this problem. #1 is the request and I've attached a photo of the table(s) I'm working from. This is where I've gotten so far...
Blockquote
SELECT SUM(Account_MRR)
FROM Accounts
JOIN Success
ON ID = AccountID
Where Type IS NOT NULL
Blockquote
Thank you SO much in advance for any and all help.
- Given the sample tables below, write a SQL query to show the combined Account MRR by Region for active contracts of at least 6 months with at least one Success engagement.