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.