oracle 复杂算法,最佳分配算法SQL求解

insert into FLOW_PLAN (ID, PLAN_NAME, PLAN_CODE, WATER_TOTAL)

values ('4', '100T', '004', 100);

insert into FLOW_PLAN (ID, PLAN_NAME, PLAN_CODE, WATER_TOTAL)

values ('1', '10T', '001', 10);

insert into FLOW_PLAN (ID, PLAN_NAME, PLAN_CODE, WATER_TOTAL)

values ('2', '20T', '002', 20);

insert into FLOW_PLAN (ID, PLAN_NAME, PLAN_CODE, WATER_TOTAL)

values ('3', '30T', '003', 30);

commit;

insert into FLOW_PLAN_DETAIL (ID, WATER_PLAN_ID, PER_USER_MONEY, USERS_LIMIT_BEGIN, USERS_LIMIT_END, PER_EXCEED_CHARGE)

values ('1', '1', 35, 1, 99, 2);

insert into FLOW_PLAN_DETAIL (ID, WATER_PLAN_ID, PER_USER_MONEY, USERS_LIMIT_BEGIN, USERS_LIMIT_END, PER_EXCEED_CHARGE)

values ('2', '1', 33.5, 100, 199, 2);

insert into FLOW_PLAN_DETAIL (ID, WATER_PLAN_ID, PER_USER_MONEY, USERS_LIMIT_BEGIN, USERS_LIMIT_END, PER_EXCEED_CHARGE)

values ('3', '1', 31.5, 200, 299, 2);

insert into FLOW_PLAN_DETAIL (ID, WATER_PLAN_ID, PER_USER_MONEY, USERS_LIMIT_BEGIN, USERS_LIMIT_END, PER_EXCEED_CHARGE)

values ('4', '2', 65, 1, 99, 2);

insert into FLOW_PLAN_DETAIL (ID, WATER_PLAN_ID, PER_USER_MONEY, USERS_LIMIT_BEGIN, USERS_LIMIT_END, PER_EXCEED_CHARGE)

values ('5', '2', 62, 100, 199, 2);

insert into FLOW_PLAN_DETAIL (ID, WATER_PLAN_ID, PER_USER_MONEY, USERS_LIMIT_BEGIN, USERS_LIMIT_END, PER_EXCEED_CHARGE)

values ('6', '2', 60, 200, 299, 2);

insert into FLOW_PLAN_DETAIL (ID, WATER_PLAN_ID, PER_USER_MONEY, USERS_LIMIT_BEGIN, USERS_LIMIT_END, PER_EXCEED_CHARGE)

values ('7', '3', 90, 1, 99, 2);

insert into FLOW_PLAN_DETAIL (ID, WATER_PLAN_ID, PER_USER_MONEY, USERS_LIMIT_BEGIN, USERS_LIMIT_END, PER_EXCEED_CHARGE)

values ('8', '3', 85, 100, 199, 2);

insert into FLOW_PLAN_DETAIL (ID, WATER_PLAN_ID, PER_USER_MONEY, USERS_LIMIT_BEGIN, USERS_LIMIT_END, PER_EXCEED_CHARGE)

values ('9', '3', 83, 200, 299, 2);

commit;

insert into FLOW_USER_USED (ID, USER_NAME, USER_USED_WATER, USER_USED_BEGIN_DATE, FLOW_PLAN_ID, CHARGE_MONEY)

values ('1', '1', 10, to_date('17-01-2017', 'dd-mm-yyyy'), null, null);

insert into FLOW_USER_USED (ID, USER_NAME, USER_USED_WATER, USER_USED_BEGIN_DATE, FLOW_PLAN_ID, CHARGE_MONEY)

values ('2', '2', 15, to_date('16-01-2017', 'dd-mm-yyyy'), null, null);

insert into FLOW_USER_USED (ID, USER_NAME, USER_USED_WATER, USER_USED_BEGIN_DATE, FLOW_PLAN_ID, CHARGE_MONEY)

values ('3', '3', 34, to_date('15-01-2017', 'dd-mm-yyyy'), null, null);

insert into FLOW_USER_USED (ID, USER_NAME, USER_USED_WATER, USER_USED_BEGIN_DATE, FLOW_PLAN_ID, CHARGE_MONEY)

values ('4', '4', null, null, null, null);

insert into FLOW_USER_USED (ID, USER_NAME, USER_USED_WATER, USER_USED_BEGIN_DATE, FLOW_PLAN_ID, CHARGE_MONEY)

values ('5', '5', null, null, null, null);

insert into FLOW_USER_USED (ID, USER_NAME, USER_USED_WATER, USER_USED_BEGIN_DATE, FLOW_PLAN_ID, CHARGE_MONEY)

values ('6', '6', null, null, null, null);

insert into FLOW_USER_USED (ID, USER_NAME, USER_USED_WATER, USER_USED_BEGIN_DATE, FLOW_PLAN_ID, CHARGE_MONEY)

values ('7', '7', 38, to_date('11-12-2017', 'dd-mm-yyyy'), null, null);

insert into FLOW_USER_USED (ID, USER_NAME, USER_USED_WATER, USER_USED_BEGIN_DATE, FLOW_PLAN_ID, CHARGE_MONEY)

values ('8', '8', 40, to_date('13-12-2017', 'dd-mm-yyyy'), null, null);

insert into FLOW_USER_USED (ID, USER_NAME, USER_USED_WATER, USER_USED_BEGIN_DATE, FLOW_PLAN_ID, CHARGE_MONEY)

values ('9', '9', 43, to_date('15-12-2017', 'dd-mm-yyyy'), null, null);

commit;