AI Micro-Internship · ~240 min · builder
Answer 5 business questions in SQL
SQL is still the most-demanded data skill in job listings. Load a real dataset into SQLite or DuckDB, write queries that answer 5 genuinely useful questions, and document where the AI’s SQL suggestions were wrong — because they will be.
Steps
- 01Pick a real dataset with at least 2 relatable tables (or split one CSV into two — e.g. orders + products). Load it into SQLite/DuckDB (Colab works).
- 02Write 5 business questions a manager would ask, at increasing difficulty: a filter, an aggregate, a GROUP BY, a JOIN, and one with a subquery or window.
- 03Write the SQL for each — AI-assisted is fine, but run everything and verify the results make sense against the raw data.
- 04Keep an honesty log: at least one case where AI-suggested SQL was wrong or misleading, and how you caught it.
Tools: SQLite or DuckDB (Colab-friendly), An AI assistant, A real dataset
Your submission
Submit the dataset description, a public notebook/repo with the working queries, all 5 questions + SQL + results, and the AI-correction log.