Overdue Fine Calculation

Write a SQL query to calculate hypothetical overdue fines (Rs. 5 per day for overdue books).

Expected Columns

• member_name
• book_title
• days_overdue
• fine_amount

Example Output

| member_name | book_title | days_overdue | fine_amount | |-------------|------------|--------------|-------------| | Vidya Lakshmi | The Argumentative Indian | 1 | 5 |