• + 1 comment

    When I run code with "select * from CITY;" I receive wrong answer with the below output. Data is queried properly, but on the end I have these 3 lines which is off course corrupting the answer. Anybody with the same issue ? I asked also for support here on hackerrank, so far no feedback.

    It`s basically stops me from proceed to the next, more interesting challenges...

    Your Output (stdout)

    6 Rotterdam NLD Zuid-Holland 593321 
    
    3878 Scottsdale USA Arizona 202705 
    
    3965 Corona USA California 124966 
    
    3973 Concord USA California 121780 
    
    3977 Cedar Rapids USA Iowa 120758 
    
    3982 Coral Springs USA Florida 117549 
    
    4054 Fairfield USA California 92256 
    
    4058 Boulder USA Colorado 91238 
    
    4061 Fall River USA Massachusetts 90555 
    
    DB21034E The command was processed as an SQL statement because it was not a 
    
    valid Command Line Processor command. During SQL processing it returned: 
    
    SQL0104N An unexpected token "database" was found following "k line. */ 
    
    uncatalog". Expected tokens may include: "JOIN <joined_table>". 
    
    SQLSTATE=42601