Exercise 78

For each battle find out the first and the last day of the month when the battle took place.
Result set: the battle name, the first day of month, the last day of month.

Information

A year is not leap year if it is evenly divisible by 100 but is not evenly divisible by 400. Thus 2000 is leap year but 1900 is not.

To solve the problem on SQL-EX.RU