Ad
  • Custom User Avatar

    Nice warm-up before tough kata's! Thanks!

  • Custom User Avatar

    This dojo makes me a poet!

    Here is my poem for this exercise:

    I tried but no way for DISTINCT
    So I listen my instinct!
    Then a way comes out SELECT FROM 
    WHERE do bring IN from WHERE without DISTINCT!
    
    No DISTINCT, no JOIN, I hear the call,
    A pure SELECT FROM—that’s all!
    A WHERE within a WHERE so keen,
    IN the answer, smooth and clean!
    
  • Custom User Avatar

    Here is my poem for this exercise:

    -- I thought I could round with ROUND(),

    -- I even thought I could cast something with CAST(),

    -- but only trunc() helped me before I truncated, while I was progressing!

    -- The decimals danced away, ROUND couldn’t stay,

    -- But trunc() stepped in, leading the way!