날아보자!

Print Prime Numbers SET @i = 2; SET @isPrime = 0; SET @result = ''; DELIMITER $$ CREATE PROCEDURE PrintPrime(IN num INT) BEGIN WHILE @i 1 DO IF @i % @j = 0 THEN SET @isPrime = 0; END IF; SET @j = @j - 1; END WHILE; IF @isPrime = 1 THEN SET @result = CONCAT(@result, @i, '&'); END IF; SET @i = @i + 1; END WHILE ; SET @result = SUBSTR(@result, ..

SELECT CONCAT(NAME, '(', LEFT(OCCUPATION,1), ')') FROM OCCUPATIONS ORDER BY NAME; SELECT CONCAT('There are a total of ', COUNT(*), ' ', LOWER(OCCUPATION), 's.') FROM OCCUPATIONS GROUP BY OCCUPATION ORDER BY COUNT(*), OCCUPATION; 11/15일 2차풀이 - 6분