what is the condition used to solve the query

[Ravikumarkummari]

Hi all, can you give your valid comments to solve this type of query.

i have two datasets

1. annuity

2. policy

annuity variables are account_no, account_value, policy_no.

policy variables are policy_no, year, p_type.

in policy_type we have the different types suppose A,B,C,D,E,F,G,H.

We consider A,B,C,D are one type let us consider it as reg_policy. The remaining all are individual.

now we want the output like

Account Number	Sum_of_acccontvalue					No_of_policies					ranks
	2010	2011	2012	2013	2014	2010	2011	2012	2013	2014	2010	2011	2012

The condition is that

1. If the no_of_policies example like in 2010 is 100 then policy_type  in that reg_policy is the maximum value compare to  remaining all. We want only that information.

2. Ranks are given based on sum_of_accountvalue with year wise.

[mohamed_zaki]

Could you give data set example and the desired output.

[LinusH]

Quite a complex query from what it sounds. Why don't you give it a go and get back to us with some more specific question?

[Patrick]

You need definitely to provide some representative sample data.

"annuity variables are account_no, account_value, policy_no"  

Shouldn't there also be a "date" variable in annuity? Else how would you be able to create account_value sums by year, and how would you join "annuity" with "policy"?