Write SQL functions, which will perform the following operations. a) to display the day of the year for the given date in numeric format in the range 1 to 366.
b) to join strings "informatics" and " practices"
c) to display 5 characters from right side of the string "information".
d) to display the starting position of the substring 'city' from the string "green city".
e) to compute the square root of an integer.

Please answer this question fastly and appropriately please. I will mark you as brainlliest

Write a program that prints the day number of the year, given the date in the form month-day-year. for example, if the input is 1-1-2006, the day number is 1; if the input is 12-25-2006, the day number is 359. the program should check for a leap year. a year is a leap year if it is divisible by 4, but not divisible by 100. for example, 1992 and 2008 are divisible by 4, but not by 100. a year that is divisible by 100 is a leap year if it is also divisible by 400. for example, 1600 and 2000 are divisible by 400. however, 1800 is not a leap year because 1800 is not divisible by 400.