Welcome to Database School

SQL Query Support for Academic Homework – AdventureWorks Database

Industry: Academic / Educational

Platform: Microsoft SQL Server (AdventureWorks2019.bak)

 
  1. Project Title:
Solving SQL Homework Using AdventureWorks2019 Database

  1. Objective:
To help the client answer 3 complex SQL homework questions related to the AdventureWorks2019 database by writing, testing, and validating T-SQL queries using Microsoft SQL Server.

  1. Project Description:
The client, a student unfamiliar with advanced SQL, needed help completing 3 SQL queries based on a pre-existing .bak database file. The questions were in French and translated into English for processing. The task required mapping specific business logic to correct tables and fields in the AdventureWorks schema, particularly:
  1. a) Understanding the components of TotalDue (subtotal + tax + freight).
  2. b) Resolving relationships between customer and store via BusinessEntityID.
  3. c) Retrieving VacationHours from the Human Resources schema.
  The goal was not just to write syntactically correct queries but to align logic with real-world data modeling.

  1. Tools & Technologies Used:
  2. a) Microsoft SQL Server 2019
  3. b) AdventureWorks2019 Sample Database
  4. c) T-SQL Scripting
  5. d) Google Drive (for file sharing)
  6. e) Snipping Tool (for validation screenshots)
 
  1. Key Features Implemented:
  2. a) SQL query to retrieve the largest order amount (TotalDue) based on freight and tax.
  3. b) Join queries using foreign keys from Sales.Customer and Sales.Store tables.
  4. c) Data retrieval from HumanResources.Employee using the VacationHours attribute.
  5. d) Fully tested and verified in SQL Server with proof via screenshots.
 
  1. Challenges Faced & Solutions:
Challenge Solution
Homework questions were initially in French Client translated them, and clarification was requested where needed
Complex database with many related tables Identified correct table relationships with client guidance and schema review
Interpretation issues for business logic terms like “transport + tax” Resolved through client feedback and used TotalDue as sum of components
File transfer issues with .bak on Fiverr Used Google Drive for secure, efficient sharing

  1. Outcome & Benefits:
  2. a) Delivered fully working queries that were ready to execute in MS SQL Server.
  3. b) Provided clear answers with documentation and tested output.
  4. c) Client was satisfied, paid $40 (adjusted from $50 for fairness), and promised future collaboration.
  5. d) Strengthened trust and communication with international clients on academic tasks.
 
  1. Client Testimonial (Summary):
“Perfect, thank you so much… I will also contact you in the future if I ever need more help.”