Company Database SQL Queries and Reports

← All projects

Company Database SQL Queries and Reports

CSC 1403 Database Concepts · Academic project · Group project

  • Academic project
  • SQL

Our team wrote four SQL queries against a sample company database. Three queries use the Employee table to review higher salaries, compare staffing and average pay across branches, and list a supervisor’s direct reports. The fourth joins Employee, Works_With, and Client to show employee sales by client. The report includes sample results and explains how database administrators and branch managers use the database.

Project documents

  • Company Database SQL Queries and Reports.docxWord · 860 KB