========================================================================
Sakila Video — Rentals and Revenue — Grading Feedback
========================================================================
Student:    Marcus Webb
File:       Marcus Webb - Sakila Rentals - Mar 4, 2026 0938 AM - submission.sql
Score:      81.00 / 100.00 (81.0%)
Grade:      B-

------------------------------------------------------------------------
Question 1 — 8.00 / 8.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT film.title, film.rental_rate, film.rating FROM sakila.film WHERE film.rental_rate > 3.00;

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 2 — 3.00 / 8.00 (37.5%)
------------------------------------------------------------------------
Submitted:
    SELECT customer.first_name, customer.last_name, customer.email FROM sakila.customer ORDER BY customer.last_name ASC, customer.first_name ASC;

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 title, length, replacement_cost FROM film WHERE length > 120 AND replacement_cost < 00 ORDER BY length ASC;

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 4 — 8.00 / 8.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT staff.first_name, staff.last_name, staff.email FROM sakila.staff WHERE staff.active = 1 ORDER BY staff.last_name ASC;

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 5 — 12.00 / 12.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT category.name, COUNT(film_category.film_id) AS total_films FROM sakila.category JOIN sakila.film_category ON category.category_id = film_category.category_id GROUP BY category.category_id, category.name ORDER BY total_films DESC;

Feedback:
  + Perfect! All requirements met.

------------------------------------------------------------------------
Question 6 — 14.00 / 14.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT customer.first_name, customer.last_name, SUM(payment.amount) AS total_paid FROM sakila.customer JOIN sakila.payment ON customer.customer_id = payment.customer_id GROUP BY customer.customer_id, customer.first_name, customer.last_name ORDER BY total_paid DESC LIMIT 10;

Feedback:
  + Perfect! All requirements met.

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

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

------------------------------------------------------------------------
Question 8 — 28.00 / 28.00 (100.0%)
------------------------------------------------------------------------
Submitted:
    SELECT category.name, ROUND(AVG(film.rental_rate), 2) AS avg_rental_rate, SUM(payment.amount) AS total_revenue FROM sakila.category JOIN sakila.film_category ON category.category_id = film_category.category_id JOIN sakila.film ON film_category.film_id = film.film_id JOIN sakila.inventory ON film.film_id = inventory.film_id JOIN sakila.rental ON inventory.inventory_id = rental.inventory_id JOIN sakila.payment ON rental.rental_id = payment.rental_id GROUP BY category.category_id, category.name HAVING SUM(payment.amount) > 5000 ORDER BY total_revenue DESC;

Feedback:
  + Perfect! All requirements met.