문제 link
https://www.hackerrank.com/challenges/print-prime-numbers/problem
Code link
https://github.com/JamesJung01/Hackerrank_sql/blob/main/02_Medium/Print_Prime_Numbers.sql
SELECT GROUP_CONCAT(NUMB SEPARATOR '&') FROM ( SELECT @num:=@num+1 as NUMB FROM information_schema.tables t1, information_schema.tables t2, (SELECT @num:=1) tmp ) tempNum WHERE NUMB<=1000 AND NOT EXISTS( SELECT * FROM ( SELECT @nu:=@nu+1 as NUMA FROM information_schema.tables t1, information_schema.tables t2, (SELECT @nu:=1) tmp1 LIMIT 1000 ) tatata WHERE FLOOR(NUMB/NUMA)=(NUMB/NUMA) AND NUMA<NUMB AND NUMA>1 );