Field content
Customer number
Toward customer type is 0, 1 is for private

day average depositsThis is demand, there are source table above fields
Contrast at the beginning of the requirement, it is the end of last year, according to the customer number statistics, brought to the customer, annual average more than $20000, for private customers more than 100000 new



This how to do, how to write ah, is that I am a little stupid, new data types is that two of the target, a new effective, an annual average daily, annual average daily can access directly, another I didn't have much, behind the field to be used and table are the same table in daily field

CodePudding user response:

New, how to calculate the effective date fields also have no, how to compare,

CodePudding user response:

Have the date to do then, bosses

CodePudding user response:

reference 1st floor RINK_1 response:

new, how to calculate the effective date fields also have no, how to compare,

Have the date, how to write