= Use-case 0012 - View Event Attendance Summary =

'''Initiating actor:''' Wedding Organizer (Assistant)

'''Other actors:''' Bride / Groom (Wedding owner)

== Description ==
The organizer or wedding owner views attendance list and statistics per event, including number of attendees per role/table and overall status.

== Scenario ==
1. The user selects an event.
2. The system lists attendance details for all guests.

{{{
SET search_path TO project;

SELECT a.attendance_id, g.first_name, g.last_name, a.status, a.table_number, a.role
FROM attendance a
JOIN guest g ON a.guest_id = g.guest_id
WHERE a.event_id = :event_id
ORDER BY a.table_number NULLS LAST, g.last_name, g.first_name;
}}}

3. The system shows a summary (counts by status).

{{{
SET search_path TO project;

SELECT status, COUNT(*) AS total
FROM attendance
WHERE event_id = :event_id
GROUP BY status
ORDER BY total DESC;
}}}

4. The system can show guests per table (optional view).

{{{
SET search_path TO project;

SELECT table_number, COUNT(*) AS guests_on_table
FROM attendance
WHERE event_id = :event_id AND table_number IS NOT NULL
GROUP BY table_number
ORDER BY table_number;
}}}