main

SELECT ANIMAL_ID, NAME, DATE_FORMAT(DATETIME,'%Y-%m-%d') AS '날짜' FROM ANIMAL_INS ORDER BY ANIMAL_ID

SELECT ins.ANIMAL_ID, ins.NAME FROM ANIMAL_INS ins LEFT JOIN ANIMAL_OUTS outs ON ins.ANIMAL_ID = outs.ANIMAL_ID WHERE outs.DATETIME IS NOT NULL ORDER BY outs.DATETIME - ins.DATETIME DESC limit 2

SELECT CASE WHEN [컬럼명] LIKE 'AAA%' THEN [조건값1] WHEN [컬럼명] LIKE 'BBB%' THEN [조건값2] ELSE [조건값3] END AS [새로운컬럼명] FROM [테이블명] SELECT ANIMAL_ID, NAME, CASE WHEN SEX_UPON_INTAKE LIKE 'Neutered%' THEN 'O' WHEN SEX_UPON_INTAKE LIKE 'Spayed%' THEN 'O' ELSE 'X' END AS '중성화' FROM ANIMAL_INS ORDER BY ANIMAL_ID;

class Solution { public int solution(int[][] sizes) { int answer = 0; int max_width = 0; int max_height = 0; int width = 0; int height = 0; for(int i = 0; i = sizes[i][1]){ width = sizes[i][0]; height = sizes[i][1]; } else { width = sizes[i][1]; height = sizes[i][0]; } if(max_width < width) max_width = width; if(max_height < height) max_height = height; } an..

class Solution { public String solution(int num) { String answer = ""; if(num%2==0){ answer="Even"; }else{ answer="Odd"; } return answer; } }