Would like an overview of the Recursion Exercises

[datadrivenlucas]

Hi, I find this GitHub very interesting. For now, I'm interested in doing the recursion exercises, but I don't find the assignments for those exercises. Only the solutions are in one folder. How do I easily search the right assignments for the recursion exercises?

[smpetersgithub]

Hello, glad to hear from you. There is no PDF that contains the exercises. It's simply a folder in the repo that contains example recursive queries. Feel free to reach out to me with any questions. Get Outlook for iOS<https://aka.ms/o0ukef>

…

________________________________ From: Lucas Wittevrongel ***@***.***> Sent: Saturday, May 17, 2025 11:35:12 PM To: smpetersgithub/AdvancedSQLPuzzles ***@***.***> Cc: Subscribed ***@***.***> Subject: [smpetersgithub/AdvancedSQLPuzzles] Would like an overview of the Recursion Exercises (Discussion #42) Hi, I find this GitHub very interesting. For now, I'm interested in doing the recursion exercises, but I don't find the assignments for those exercises. Only the solutions are in one folder. How do I easily search the right assignments for the recursion exercises? — Reply to this email directly, view it on GitHub<#42>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ANP5G75B5WYNJJ4F7GYSQ5T27AEYBAVCNFSM6AAAAAB5LKT2V6VHI2DSMVQWIX3LMV43ERDJONRXK43TNFXW4OZYGM2DCMJVHE>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[Logan20142025]

Hi Bro, thank you for your work. For puzzle 2, the recursion excercise. your solution is not working when I use the MySQL to make practice.

I tried so many times , and solved the issue by changing the key words from "with cte-recursion as " to " with recursive cte_recursion as".

I don't know where to feedback this issue as this is my first time using github, so I leave a comments here for you.

[smpetersgithub]

The solutions are written in T-SQL (SQL Server). You can try using ChatGPT (or a similar tool) to convert the code to MySQL. Hope this helps! Sent from Outlook<http://aka.ms/weboutlook>

…

________________________________ From: Logan20142025 ***@***.***> Sent: Thursday, May 22, 2025 3:57 AM To: smpetersgithub/AdvancedSQLPuzzles ***@***.***> Cc: Scott Peters ***@***.***>; Comment ***@***.***> Subject: Re: [smpetersgithub/AdvancedSQLPuzzles] Would like an overview of the Recursion Exercises (Discussion #42) Hi Bro, thank you for your work. For puzzle 2, the recursion excercise. your solution is not working when I use the MySQL to make practice. I tried so many times , and solved the issue by changing the key words from "with cte-recursion as " to " with recursive cte_recursion as". I don't know where to feedback this issue as this is my first time using github, so I leave a comments here for you. — Reply to this email directly, view it on GitHub<#42 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ANP5G725TDHTVL6V75IEYNL27WGOTAVCNFSM6AAAAAB5LKT2V6VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTGMRTGE4TGOI>. You are receiving this because you commented.Message ID: ***@***.***>