Creative Code

SELECT B.CATEGORY, B.PRICE AS MAX_PRICE, B.PRODUCT_NAME FROM (SELECT CATEGORY, MAX(PRICE) AS PRICE FROM FOOD_PRODUCT GROUP BY CATEGORY) A, FOOD_PRODUCT B WHERE A.CATEGORY = B.CATEGORY AND A.PRICE = B.PRICE AND (B.CATEGORY = '과자' OR B.CATEGORY = '국' OR B.CATEGORY = '김치' OR B.CATEGORY = '식용유') ORDER BY B.PRICE DESC;

SELECT ANIMAL_ID, INS.ANIMAL_TYPE, INS.NAME FROM ANIMAL_INS INS JOIN ANIMAL_OUTS OUTS USING (ANIMAL_ID) WHERE INS.SEX_UPON_INTAKE LIKE 'Intact%' AND (OUTS.SEX_UPON_OUTCOME LIKE 'Spayed%' OR OUTS.SEX_UPON_OUTCOME LIKE 'Neutered%') ORDER BY ANIMAL_ID;

https://www.acmicpc.net/problem/2225 2225번: 합분해 첫째 줄에 답을 1,000,000,000으로 나눈 나머지를 출력한다. www.acmicpc.net #include #include using namespace std; long long dp[201][201]; int main() { int N, K; cin >> N >> K; for (int i = 1; i

※main.cpp파일 #include #include "complex.h" int main() { Complex c1; Complex c2 = 3.0; Complex c3(3.0,4.0); const Complex c4 = c3; // Complex c4(c3) c1.real(c3.real()); c1.imag(c3.imag()); c1 = c3; if (c1 == c3) std::cout

※main.cpp파일 #include #include "employee.h" int main() { Employee *pEmployees[5]; pEmployees[0] = new Employee(1,"Park Jung Seok ",0); pEmployees[1] = new Employee(2,"Sung Young Ho",pEmployees[0]); pEmployees[2] = new Employee(3,"Sim Sung Suk",pEmployees[0]); pEmployees[3] = new Employee(4,"Choi Su Gil",pEmployees[2]); pEmployees[4] = new Employee(5,"Kim Young Gin",pEmployees[0]); for (int i = 0;..