A real estate agent, the agent at the same time a number of real estate projects, the salesman can also responsible for any real estate sales, the company now want to accounting each building cost of personnel salary each month, accounting rules are: if the salesman did not single out during the month, then split by the number of all the buildings that the salesman wages; If the salesman has a single, according to each building dish out the single number between the salesman's salary, not a single real estate business accounting cost, please build the database model, and use SQL to complete, can't use the if one,

CodePudding user response:

A solicitor general has a base salary and commission,
You have no base salary?

Use excel column test data and the desired results,