CREATE TABLE code_t (
 S integer,
 E integer,
 V1 integer,
 V2 float);

INSERT INTO code_t (s, e, v1, v2) values (0, 100, 410, 60.7);

INSERT INTO code_t (s, e, v1, v2) values (100, 200, 910, 125.9);
INSERT INTO code_t (s, e, v1, v2) values (200, 300, 1600, 187.9);
INSERT INTO code_t (s, e, v1, v2) values (300, 400, 3850, 280.6);
INSERT INTO code_t (s, e, v1, v2) values (400, 500, 7300, 417.7);
INSERT INTO code_t (s, e, v1, v2) values (500, 9999, 12940, 709.5);

CREATE TABLE use_t (
 id integer,
 KWH Integer
);

INSERT INTO use_t (id, kwh) values (1, 90);
INSERT INTO use_t (id, kwh) values (2, 120);
INSERT INTO use_t (id, kwh) values (3, 240);
INSERT INTO use_t (id, kwh) values (4, 360);
INSERT INTO use_t (id, kwh) values (5, 480);
INSERT INTO use_t (id, kwh) values (6, 600);

select * from code_t;
select * from use_t;
  시작     끝     기본요금 전력요금

각 아이디별 전력요금은

1. 90Kwh는 410+60.7*90 = 5870

2. 120Kwh는 910 + 60.7*100 + 125.9*20 =9498 인데 10원 아래는 버림 그래서 9490

3. 240kwh, 27770

4. 360kwh, 58130

5. 480kwh, 106220

6. 600kwh, 191170