SQL Interview Questions for Data Analysts - free files from Pivotalstats (youtube.com/@pivotalstats)

1. Install the free SQL Server Express and SSMS (SQL Server Management Studio) from Microsoft's website.
2. Open 00_create_database.sql in SSMS, connect to your server, and press F5. It builds the InterviewLab database
   (7 tables of synthetic online-shop data) from scratch. Running it again rebuilds it.
3. Open any file in the queries folder, choose InterviewLab in the database box (or run USE InterviewLab;), press F5.
   Every file starts with the interview question. Try it yourself before you open the file.
4. "20 SQL Interview Questions.pdf": each question with its pattern, the query, the result, the trap interviewers use,
   the follow-up question, and a table of what changes in PostgreSQL and MySQL.
5. data folder: the same 7 tables as CSV, if you want to load them into another database.
The data is synthetic (an imaginary online store): use it freely for practice.
