Tickets Filed on Weekends vs Weekdays

Problem

A support desk logs every ticket. Table `tickets` has `(ticket_id, agent_id, filed_on)` where `filed_on` is a date.

Report two numbers across the whole table: `weekend_count`, the number of tickets filed on a Saturday or Sunday, and `weekday_count`, the number filed Monday through Friday. The output is a single row with those two columns.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns weekend_count, weekday_count.

Starter code (SQL)

SELECT *
FROM tickets;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium