insertupdatedeleteselectcreatealterdroptruncaterenamegrantrevokecommitrollbacksavepoint테이블 생성create table student (칼럼명 타입 조건(not null 등),칼럼명 타입 조건(not
SELECT \* FROM ANIMAL_INS ORDER BY ANIMAL_ID;SELECT NAME, DATETIME FROM ANIMAL_INS ORDER BY ANIMAL_ID desc;SELECT ANIMAL_ID, NAME FROM ANIMAL_INS wher
SELECT MAX(DATETIME)FROM ANIMAL_INS;SSELECT MIN(DATETIME)FROM ANIMAL_INS;SELECT COUNT(ANIMAL_ID)FROM ANIMAL_INS;SELECT COUNT(DISTINCT NAME) countFROM
SELECT ANIMAL_TYPE, COUNT(\*) countFROM ANIMAL_INSGROUP BY ANIMAL_TYPEORDER BY ANIMAL_TYPESELECT NAME, COUNT(\*) as COUNTFROM ANIMAL_INSWHERE NAME IS
SELECT ANIMAL_IDFROM ANIMAL_INSWHERE NAME IS NULL;SELECT ANIMAL_IDFROM ANIMAL_INSWHERE NAME IS NOT NULL;SELECT ANIMAL_TYPE, IFNULL(NAME, "No name") AS
SELECT ANIMAL_OUTS.ANIMAL_ID, ANIMAL_OUTS.NAMEFROM ANIMAL_OUTS LEFT JOIN ANIMAL_INSON ANIMAL_OUTS.ANIMAL_ID = ANIMAL_INS.ANIMAL_IDWHERE ANIMAL_INS.ANI
SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKEFROM ANIMAL_INSWHERE NAME IN("Lucy", "Ella", "Pickle", "Rogan", "Sabrina", "Mitty")ORDER BY ANIMAL_IDSELECT ANI