1)REST api with pure sql 2)API for particular id 3)API for all the records