14 lines
335 B
MySQL
14 lines
335 B
MySQL
|
with numbers as (
|
||
|
|
select rownum as n from dual connect by level <= 100
|
||
|
|
),
|
||
|
|
passes as (
|
||
|
|
select doors.n door, count(passes.n) pass_number
|
||
|
|
from numbers doors
|
||
|
|
cross join numbers passes
|
||
|
|
where MOD(doors.n, passes.n) = 0 -- modulo
|
||
|
|
group by doors.n
|
||
|
|
)
|
||
|
|
select door from passes
|
||
|
|
where MOD(pass_number, 2) = 1
|
||
|
|
order by door
|