[SQL] SELECT 문 연습 – 조회, 조건, 정렬
Table 생성 및 데이터 삽입CREATE TABLE tCity( name CHAR(10) PRIMARY KEY, area INT NULL , popu INT NULL , metro CHAR(1) NOT NULL, region CHAR(6) NOT NULL);INSERT INTO tCity VALUES ('서울',605,974,'y','경기');INSERT INTO tCity VALUES ('부산',765,342,'y','경상');INSERT INTO tCity VALUES ('오산',42,21,'n','경기');INSERT INTO tCity VALUES ('청주',940,83,'n','충청');INSERT INTO tCity VALUES ('전주',205,65,'n','전라');INSERT INTO ..
2025. 8. 14.