Creative Code

SELECT ANIMAL_ID, NAME, replace(SEX_UPON_INTAKE,'Neutered Male','O') AS 중성화 FROM ANIMAL_INS WHERE SEX_UPON_INTAKE = 'Neutered Male' UNION SELECT ANIMAL_ID, NAME, replace(SEX_UPON_INTAKE,'Spayed Female','O') AS 중성화 FROM ANIMAL_INS WHERE SEX_UPON_INTAKE = 'Spayed Female' UNION SELECT ANIMAL_ID, NAME, replace(SEX_UPON_INTAKE,'Intact Male','X') AS 중성화 FROM ANIMAL_INS WHERE SEX_UPON_INTAKE = 'Intact ..

SELECT * FROM (SELECT * FROM FOOD_PRODUCT ORDER BY PRICE DESC) WHERE ROWNUM=1;

SELECT ANIMAL_ID, NAME, to_char(DATETIME,'YYYY-MM-DD') as DATETIME FROM ANIMAL_INS order by ANIMAL_ID;

SELECT ANIMAL_TYPE, NVL(NAME,'No name') AS NAME, SEX_UPON_INTAKE FROM ANIMAL_INS ORDER BY ANIMAL_ID asc;

SELECT count(DISTINCT NAME) AS COUNT FROM ANIMAL_INS WHERE NAME IS NOT NULL;

SELECT NAME,count(*) as COUNT FROM ANIMAL_INS GROUP BY NAME HAVING count(NAME) >=2 ORDER BY NAME;