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. Help me please

Acolor class has three public, integer-returning accessor methods: getred, getgreen, and getblue, and three protected, void-returning mutator methods: setred, setgreen, setblue, each of which accepts an integer parameter and assigns it to the corresponding color component. the class, alphachannelcolor-- a subclass of color-- has an integer instance variable, alpha, containing the alpha channel value, representing the degree of transparency of the color. alphachannelcolor also has a method named dissolve (void-returning, and no parameters), that causes the color to fade a bit. it does this by incrementing (by 1) all three color components (using the above accessor and mutator methods) as well as the alpha component value. write the dissolve method.