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.
See attached image for the tables.
Accounts Example
ID 100005
Name Acme
MRR $1,500
Region EMEA
Subscription Example
ID 80003
AccountID 100005
ContractLength (mo) 3
MRR $1,000
Status Active
Success Example
ID 60004
AccountID 100005
Type Services
Hi,
I have 7 years of experience in sql. I understand the query you are looking for. I can complete this in a couple of hours. Can I have a look at the table structure?
Thanks,
Arpan
$10 USD in 1 day
5.0 (2 reviews)
0.8
0.8
6 freelancers are bidding on average $22 USD for this job
Hello,
Greetings!!
I went through your requirements and I am glad to inform you that we can serve your requirements.
As I'm good in SOLVING DATABASE QUERY’s.
Let's go ahead with me I want to service for you continuously.
Now I am free, so I will start the work in your project immediately.
Thanks
Hi Team,
I can do this let me know if you are interested in giving me a chance. Will do it asap and will share this with you once you agree, Please inbox me.
Hi there,
I am a software engineer by profession and I have good knowledge on SQL.
Please let me know if you want me to take this work for you.
Regards,
Raghav