Database: insurance_policies
Question: What are the method, date and amount of each payment? Sort the list in ascending order of date.
SQL:
SELECT Payment_Method_Code ,  Date_Payment_Made ,  Amount_Payment FROM Payments ORDER BY Date_Payment_Made ASC