Prompts: Learn, Practice & Interview Prep

Create a comprehensive SQL course with a detailed roadmap and agenda.
Do the following:
1. Start with SQL fundamentals and advance to complex topics.
2. Make it beginner-friendly.
3. Include topics relevant to data analytics.
4. Focus on real-world data analytics use cases and scenarios.

I want a detailed explanation about SQL Window Functions.
Do the following:
1. Explain what Window Functions are.
2. Give an analogy.
3. Describe why we need them and when to use them.
4. Explain the syntax.
5. Provide simple examples.
6. List the top 3 use cases.

I want to understand the differences between SQL Window Functions and GROUP BY.
Do the following:
1. Explain the key differences between the two concepts.
2. Describe when to use each concept, with examples.
3. Provide the pros and cons of each concept.
4. Summarize the comparison in a clear side-by-side table.

Act as an SQL trainer and help me practice SQL Window Functions.
Do the following:
1. Make it interactive: you provide a task and give a solution.
2. Provide a sample dataset.
3. Give SQL tasks that gradually increase in difficulty.
4. Act as an SQL Server and show the results of my queries.
5. Review my queries, provide feedback, and suggest improvements.

Act as an Interviewer and prepare me for a SQL interview.
Do the following:
1. Ask common SQL interview questions.
2. Make it interactive: practice, you provide a question and give answer.
3. Gradually progress to advanced topics.
4. Evaluate my answer and give me a feedback.

Prepare me for a SQL exam.
Do the following:
1. Ask common SQL interview questions.
2. Make it interactive: practice, you provide a question and give answer.
3. Gradually progress to advanced topics.
4. Evaluate my answer and give me a feedback.