We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
I get the correct output when tried on Snowflake, but MySQL option on hackerrank shows some error.
"ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CTE1 AS
(SELECT submission_date, hacker_id, COUNT(hacker_id) AS hacker_count
FRO' at line 2"
Can anyone help me correct this.
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
15 Days of Learning SQL
You are viewing a single comment's thread. Return to all comments →
I get the correct output when tried on Snowflake, but MySQL option on hackerrank shows some error.
"ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CTE1 AS (SELECT submission_date, hacker_id, COUNT(hacker_id) AS hacker_count FRO' at line 2"
Can anyone help me correct this.