피드백을 받은 내용으로 리팩토링을 진행한 내용입니다.
코인 평균 매수 가격 (Average Buy Price) 테이블 생성 및 테스트 데이터 추가
CREATE TABLE ABP (id integer primary key, user_id integer, ticker text, avg float);
INSERT INTO ABP (user_id, ticker, avg) VALUES (135, 'KRW-BTC', 23070000.0);
INSERT INTO ABP (user_id, ticker, avg) VALUES (135, 'KRW-NEO', 9220.0);
INSERT INTO ABP (user_id, ticker, avg) VALUES (135, 'KRW-WAVES', 3245.0);
INSERT INTO ABP (user_id, ticker, avg) VALUES (63, 'KRW-WAVES', 3250.0);
INSERT INTO ABP (user_id, ticker, avg) VALUES (15, 'KRW-XEM', 44.0);
INSERT INTO ABP (user_id, ticker, avg) VALUES (16, 'KRW-ADA', 455.0);
INSERT INTO ABP (user_id, ticker, avg) VALUES (105, 'KRW-REP', 7155.0);
INSERT INTO ABP (user_id, ticker, avg) VALUES (15, 'KRW-STORJ', 423.0);
INSERT INTO ABP (user_id, ticker, avg) VALUES (222, 'KRW-XEM', 80.0);
INSERT INTO ABP (user_id, ticker, avg) VALUES (222, 'KRW-ARK', 362.0);