[programmers] 문제 풀이 02

| 중복 제거하기

https://school.programmers.co.kr/learn/courses/30/lessons/59408

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

| 나이 출력

https://school.programmers.co.kr/learn/courses/30/lessons/120820

class Solution {
    public int solution(int age) {
        int answer = 0;
        int year = 2024;
        
        answer = year - age - 1;
        
        return answer;
    }
}

| 경기도에 위치한 식품창고 목록 출력하기

https://school.programmers.co.kr/learn/courses/30/lessons/131114

SELECT WAREHOUSE_ID, 
       WAREHOUSE_NAME, 
       ADDRESS, 
       IFNULL(FREEZER_YN, 'N') AS FREEZER_YN
  FROM FOOD_WAREHOUSE
 WHERE ADDRESS LIKE '%경기도%'
 ORDER BY WAREHOUSE_ID ASC

| 가격이 제일 비싼 식품의 정보 출력하기

https://school.programmers.co.kr/learn/courses/30/lessons/131115

SELECT PRODUCT_ID, PRODUCT_NAME, PRODUCT_CD, CATEGORY, PRICE
  FROM FOOD_PRODUCT
 ORDER BY PRICE DESC LIMIT 1;

| 흉부외과 또는 일반외과 의사 목록 출력하기

https://school.programmers.co.kr/learn/courses/30/lessons/132203

SELECT DR_NAME, DR_ID, MCDP_CD, DATE_FORMAT(HIRE_YMD, '%Y-%m-%d') HIRE_YMD
  FROM DOCTOR
 WHERE MCDP_CD = 'CS' OR MCDP_CD = 'GS'
 ORDER BY HIRE_YMD DESC, DR_NAME;

| 역순 정렬하기

https://school.programmers.co.kr/learn/courses/30/lessons/59035

SELECT NAME, DATETIME
  FROM ANIMAL_INS
 ORDER BY ANIMAL_ID DESC

| 두 수의 차

https://school.programmers.co.kr/learn/courses/30/lessons/120803

class Solution {
    public int solution(int num1, int num2) {
        int answer = 0;
        
        answer = num1 - num2;
        
        return answer;
    }
}

| NULL 처리하기

https://school.programmers.co.kr/learn/courses/30/lessons/59410

SELECT ANIMAL_TYPE, IFNULL(NAME, 'No name') NAME, SEX_UPON_INTAKE
  FROM ANIMAL_INS

| 나머지 구하기

https://school.programmers.co.kr/learn/courses/30/lessons/120810

class Solution {
    public int solution(int num1, int num2) {
        int answer = 0;
        
        answer = num1 % num2;
        
        return answer;
    }
}