title: How do I get the number of days in a month for the specific date in that row of data using SQL?
body: <p>For example, if I have a data set including two columns, one which shows the month as a number and the other which shows the year (result of grouping my data using GROUP BY), I want to add another column called 'Days in the month' which will display the number of days in the respective month. Is there a way I can do this? Is there some function I can add in the SELECT clause?</p>
  
  <p>I want to do this since there are further calculations I need to do with that number for each row. </p>