========================================================================
Pedal Works — Service and Sales Analysis — Grading Feedback
========================================================================
Student:    Marcus Webb
File:       Marcus Webb - Pedal Works Analysis - Mar 4, 2026 0938 AM - submission.sql
Score:      83.00 / 100.00 (83.0%)
Grade:      B

------------------------------------------------------------------------
Question 1 — 8.00 / 8.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT customers.firstName, customers.lastName, customers.email FROM bikeshop.customers WHERE customers.city = 'Green Bay';

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 2 — 3.00 / 8.00 (37.5%)
------------------------------------------------------------------------
Submitted:
    SELECT bikes.brand, bikes.model, bikes.bikeType, bikes.purchasePrice FROM bikeshop.bikes ORDER BY bikes.purchasePrice DESC;

Feedback:
  + Significant issues found. Review requirements carefully.

Point deductions:
  ! Query requires a WHERE clause but none is present (-5)

------------------------------------------------------------------------
Question 3 — 8.00 / 8.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT partName, partNumber, category, unitCost FROM parts WHERE partName LIKE '%bundle%' ORDER BY unitCost ASC;

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 4 — 8.00 / 8.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT employees.firstName, employees.lastName, employees.role, employees.hourlyRate FROM bikeshop.employees WHERE employees.role = 'Technician' ORDER BY employees.hourlyRate DESC;

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 5 — 12.00 / 12.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT repairOrders.repairOrderId, repairOrders.dropOffDate, repairOrders.status, employees.firstName, employees.lastName FROM bikeshop.repairOrders JOIN bikeshop.employees ON repairOrders.employeeId = employees.employeeId WHERE repairOrders.status = 'In Progress' ORDER BY repairOrders.dropOffDate ASC;

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 6 — 12.00 / 12.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT stores.storeName, stores.city, COUNT(repairOrders.repairOrderId) AS totalRepairOrders FROM bikeshop.stores LEFT JOIN bikeshop.repairOrders ON stores.storeId = repairOrders.storeId GROUP BY stores.storeId, stores.storeName, stores.city ORDER BY totalRepairOrders DESC;

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 7 — 0.00 / 12.00 (0.0%)
------------------------------------------------------------------------
Feedback:
  + No query submitted for this question.

Point deductions:
  ! Query not found or empty (-all points)

------------------------------------------------------------------------
Question 8 — 32.00 / 32.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT customers.firstName, customers.lastName, customers.city, COUNT(DISTINCT repairOrders.repairOrderId) AS totalRepairOrders, SUM(repairItems.lineTotal) AS totalRevenue FROM bikeshop.customers JOIN bikeshop.bikes ON customers.customerId = bikes.customerId JOIN bikeshop.repairOrders ON bikes.bikeId = repairOrders.bikeId JOIN bikeshop.repairItems ON repairOrders.repairOrderId = repairItems.repairOrderId GROUP BY customers.customerId, customers.firstName, customers.lastName, customers.city HAVING SUM(repairItems.lineTotal) > 500 ORDER BY totalRevenue DESC;

Feedback:
  + Perfect! All requirements met.