SPP57_Exercise

This repository contains my solution SQL queries for "SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a learn-by-doing approach" Book.

How to Run

Requirements

Microsoft SQL Server Express Edition Installed
SQL Server Management Studio Intalled
Practice data base set up
- Youtube instruction
- problem data set
pyodbc Python package installed

Running the code

Add MSSQL Server name to the system environment variable. Set variable name as MSSQL_SERVER
Open SPP57.ipynb with pyodbc installed Python kernel