sql 자바 연동 테이블에 안 적고 평균,총합 넣는 법
DROP TABLE stuscores;
CREATE TABLE stuscores(
sno INT PRIMARY KEY,
sname VARCHAR(5),
korscore INT,
engscore INT,
mathscore INT
);
SELECT * FROM stuscores;
INSERT INTO stuscores
VALUES(1,'신짱구',50,60,40),
(2,'신짱아',70,60,50),(3,'신형만',80,90,70),(4,'봉미선',50,80,30),(5,'김철수',70,30,90);
SELECT sno,sname,(korscore+engscore+mathscore)/3 AS average FROM stuscores WHERE (korscore+engscore+mathscore)/3 >= 60;
SELECT sno,sname,(korscore+engscore+mathscore)/3 AS average FROM stuscores WHERE (korscore+engscore+mathscore)/3 < 60;
SELECT sno,sname,korscore,engscore,mathscore,(korscore+engscore+mathscore) AS SUM FROM stuscores WHERE (korscore+engscore+mathscore);
SELECT sno,sname,korscore,engscore,mathscore,(korscore+engscore+mathscore) AS SUM FROM stuscores WHERE (korscore+engscore+mathscore) <170;
SELECT sno,sname,korscore,engscore,mathscore,(korscore+engscore+mathscore)AS sum,(korscore+engscore+mathscore)/3 AS average FROM stuscores WHERE (korscore+engscore+mathscore)/3 < 60;
Share article
