Creative Code

SELECT SUBSTR(PRODUCT_CODE,1,2) AS CATEGORY, COUNT(*) PRODUCTS FROM PRODUCT GROUP BY SUBSTR(PRODUCT_CODE,1,2) ORDER BY CATEGORY;

SELECT ANIMAL_TYPE, COUNT(ANIMAL_TYPE) FROM ANIMAL_INS GROUP BY ANIMAL_TYPE

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;