Check out example codes for "get records in sql according to month name and count". It will help you in understanding the concepts better.

Code Example 1

SELECT EXTRACT(month FROM dateofappointment) "Month", count(*)
FROM appointment
WHERE EXTRACT(YEAR FROM dateofappointment) = '2014'
GROUP BY EXTRACT(month FROM dateofappointment)
ORDER BY EXTRACT(month FROM dateofappointment);

Learn ReactJs, React Native from akashmittal.com