<jupyter_start><jupyter_text>Weather Observation Station 11https://www.hackerrank.com/challenges/weather-observation-station-11/problemQ.Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.<jupyter_code>QUERY = """
    SELECT DISTINCT CITY
    FROM STATION
    WHERE LEFT(CITY, 1) NOT IN ('A','E','I','O','U')
        OR RIGHT(CITY, 1) NOT IN ('A','E','I','O','U')
"""<jupyter_output><empty_output><jupyter_text>New companieshttps://www.hackerrank.com/challenges/the-company/problem<jupyter_code>QUERY = """
    SELECT C.company_code
         , C.founder
         , COUNT(DISTINCT L.lead_manager_code)
         , COUNT(DISTINCT S.senior_manager_code)
         , COUNT(DISTINCT M.manager_code)
         , COUNT(DISTINCT E.employee_code)
    FROM Company C
         LEFT JOIN Lead_Manager L ON C.company_code = L.company_code
         LEFT JOIN Senior_Manager S ON L.lead_manager_code = S.lead_manager_code
         LEFT JOIN Manager M ON S.senior_manager_code = M.senior_manager_code
         LEFT JOIN Employee E ON M.manager_code = E.manager_code
    GROUP BY C.company_code, C.founder
    ORDER BY C.company_code
"""<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.1032258064516129, 'fraction_numerical': 0.004838709677419355, 'mean_word_length': 3.6654135338345863, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 9, 'https://': 2, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '2', 'dir': 'jupyter-structured-clean-dedup', 'id': '286944', 'license': 'MIT', 'n_tokens_mistral': 453, 'n_tokens_neox': 403, 'n_words': 99, 'path': '03_sql/220210 hackerrank solution.ipynb', 'repo_name': 'y-moon20/TIL', 'size': '1240'}