========================================================================
Chinook Music Store — Sales Analysis — Grading Feedback
========================================================================
Student:    Aisha Lund
File:       Aisha Lund - Chinook Sales Analysis - Mar 4, 2026 0938 AM - submission.sql
Score:      71.00 / 100.00 (71.0%)
Grade:      C-

------------------------------------------------------------------------
Question 1 — 1.00 / 5.00 (20.0%)
------------------------------------------------------------------------
Submitted:
    SELECT Customer.FirstName, Customer.LastName, Customer.Email FROM chinook.Customer WHERE Customer.Country = 'USA';

Feedback:
  + Significant issues found. Review requirements carefully.

Point deductions:
  ! Query requires an ORDER BY clause but none is present (-4)

------------------------------------------------------------------------
Question 2 — 0.00 / 5.00 (0.0%)
------------------------------------------------------------------------
Submitted:
    SELECT Track.Name, Track.UnitPrice FROM chinook.Track ORDER BY Track.UnitPrice DESC, Track.Name ASC;

Feedback:
  + Significant issues found. Review requirements carefully.

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

------------------------------------------------------------------------
Question 3 — 10.00 / 10.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT Name, Name, Name FROM Track JOIN Genre ON GenreId = GenreId JOIN MediaType ON MediaTypeId = MediaTypeId ORDER BY Name ASC, Name ASC;

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 4 — 10.00 / 10.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT Artist.Name, COUNT(Album.AlbumId) AS AlbumCount FROM chinook.Artist LEFT JOIN chinook.Album ON Artist.ArtistId = Album.ArtistId GROUP BY Artist.ArtistId, Artist.Name ORDER BY AlbumCount DESC, Artist.Name ASC;

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 5 — 15.00 / 15.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT Genre.Name, COUNT(Track.TrackId) AS TrackCount FROM chinook.Genre JOIN chinook.Track ON Genre.GenreId = Track.GenreId GROUP BY Genre.GenreId, Genre.Name HAVING COUNT(Track.TrackId) > 50 ORDER BY TrackCount DESC;

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 6 — 15.00 / 15.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT Employee.FirstName, Employee.LastName, Employee.Title, SUM(Invoice.Total) AS TotalRevenue FROM chinook.Employee JOIN chinook.Customer ON Employee.EmployeeId = Customer.SupportRepId JOIN chinook.Invoice ON Customer.CustomerId = Invoice.CustomerId WHERE Employee.Title = 'Sales Support Agent' GROUP BY Employee.EmployeeId, Employee.FirstName, Employee.LastName, Employee.Title ORDER BY TotalRevenue DESC;

Feedback:
  + Perfect! All requirements met.

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

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

------------------------------------------------------------------------
Question 8 — 20.00 / 20.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT Invoice.BillingCountry, COUNT(Invoice.InvoiceId) AS InvoiceCount, ROUND(SUM(Invoice.Total), 2) AS TotalRevenue, CASE WHEN SUM(Invoice.Total) > 100 THEN 'High' WHEN SUM(Invoice.Total) >= 50 THEN 'Medium' ELSE 'Low' END AS RevenueTier FROM chinook.Invoice GROUP BY Invoice.BillingCountry ORDER BY TotalRevenue DESC;

Feedback:
  + Perfect! All requirements met.