Jump to content

Seeking help to write a basic query


koralt

Recommended Posts

Hi there!  I'm brand new to the site and am excited to be here.

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. At the very bottom is what I've been able to come up with so far...

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.

This is what I've tried to write so far...

FROM Accounts

JOIN Success

ON ID = AccountID

Where Type IS NOT NULL

SQL Query.png

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...