Write a query against table PAYDAY that will show the number of days between the payday and the last day of the month

Q. Write a query against table PAYDAY that will show the number of days between the payday (CYCLEDATE column) and the last day of the month (LAST_DAY function).

 
 
 
 
 
	 
Month
 
	 
Days between payday and first days of next month
 
 
 
	 
--------
 
	 
-------
 
 
 
	 
January
 
	 
16
 
 
 
	 
February
 
	 
13
 
 
 
	 
March
 
	 
16
 
 
 
 

Format your results as below:

Answer = 

Select Month , CYCLEDATE - LAST_DAY as Days between payday and first days of next month from payday ;