educative.io

an-introductory-guide-to-sql__datajek

Topic Replies Views Activity
Command not found Error
Courses
exploring-mysql__basic-sql__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 30 March 25, 2024
How Question 3 is supposed to be solved if session variables were not covered in the course?
Courses
solution-practice-set-5__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
2 119 October 9, 2023
Is it just me, or 2nd question just doesn't make sense, is there an error?
Courses
quiz-10__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
3 158 October 9, 2023
What is meant by "secondary index" in this lesson?
Courses
continued__basic-sql__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
3 161 October 3, 2023
Not able to connect!
Courses
create-database__basic-sql__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
2 95 September 6, 2023
The alternative solution for example 1
Courses
natural-join__joins__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 73 August 28, 2023
Question # 2 quiz 2
Courses
quiz-2__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek ,  grokking-the-system-design-interview__design-gurus
0 85 June 13, 2023
How can I merge John's amount in the first example?
Courses
an-introductory-guide-to-sql__datajek ,  getting-started-with-sql-and-relational-databases__panagiotis-matsinopoulos
2 86 May 26, 2023
How can we use cursor for a dynamic sql query?
Courses
cursors__stored-procedures__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek ,  data-structures-for-coding-interviews-in-java__coderust
2 149 February 20, 2023
Why both names are inserted if the length of one string is more than 5?
Courses
quiz-16__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 125 January 9, 2023
Ascending order wrong?
Courses
group-by__basic-sql__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
0 101 December 20, 2022
Bug - 2nd question is completely the same as 1st, but has another answer with wrong info in the explanation
Courses
quiz-14__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 98 December 13, 2022
Any explanation for the now(), sleep(10), now() in question 2?
Courses
quiz-16__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 103 December 13, 2022
Explanation missing for question 4's answer
Courses
quiz-12__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
2 127 November 23, 2022
Question 1 answer using correlated subquery, as another option
Courses
solution-practice-set-5__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 99 November 19, 2022
Your window function example isn't even supported by MySQL version, and why is GROUP BY there?
Courses
solution-practice-set-5__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
0 241 November 18, 2022
Typo in expected result for question 1
Courses
practice-set-5__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 96 November 18, 2022
What "alternate rows" means in the 1st question?
Courses
quiz-10__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 143 November 14, 2022
For those wondering about question 4 answer with case and aggregate function
Courses
quiz-14__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
0 100 November 12, 2022
More details for quiz 5? Isn't TRUNCATE a DDL which can't be rolled back? And "log" is mentioned, which wan't in any topics in lessons
Courses
quiz-12__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
0 117 November 10, 2022
Aren't heap tables just tables where there is no clustered index? Why should they be in memory and not last after the restart?
Courses
quiz-12__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
0 90 November 10, 2022
Any possibility to add a clarification for the 2nd question?
Courses
quiz-11__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
0 84 November 10, 2022
Question 4 - some clarification? Correct answer contradicts the question in a way
Courses
quiz-10__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
0 103 November 10, 2022
Definition of child/parent tables for whose who wonder
Courses
quiz-7__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
0 104 November 3, 2022
Mistake in output table in Question 2, value "9" in bID from nowhere
Courses
quiz-7__practice-prep__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 108 October 28, 2022
What about DDL triggers?
Courses
what-are-triggers__triggers__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 116 October 25, 2022
No image which "explains the flow control"
Courses
conditional-statements__stored-procedures__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 128 October 24, 2022
Natural join with multiple columns of the same name
Courses
natural-join__joins__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 228 September 21, 2022
Change the capitalized letter
Courses
creating-a-view__views__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 111 September 21, 2022
Cannot Use Order By on numbers
Courses
order-by__basic-sql__an-introductory-guide-to-sql ,  an-introductory-guide-to-sql__datajek
1 93 September 16, 2022