DATE OF SUBMISSION :15-02-2017

 Write the output that the following statements will produce:
a) SELECT ROUND(7.3456, 2);
b) SELECT TRUNCATE(2.3456, 2);
 c) SELECT DAYOFMONTH('2009-08-25');
d) SELECT MONTH('2010-02-26');
e) SELECT RIGHT('Informatics', 4);

DATE OF SUBMISSION :13-02-2017

Write SQL statements to do the following:
 a) Using the three separate words "We," "study," and "MySQL," produce the following output:          "We  study MySQL"
 b) Use the string "Internet is a boon" and extract the string "net".
 c) Display the length of the string "Informatics Practices".
 d) Display the position of "My" in "Enjoying MySQL".
 e) Display the name of current month.
f) Display the date 10 years from now. Label the column "Future."
g) Display the day of week on which your birthday will fall or fell in 2010.

DATE OF SUBMISSION: 05.02.2017

FIND OPUTPUT OF THE FOLLOWING

 (i) Select length(“computer”)
 (ii) Select  right(“computer”, 3)
 (iii) Select mid(‘computer’, 3,2)
 (iv) Select power(5,2)
 (v) Select round(143.562,1)
 (vi) Select dayofmonth(‘2012-05-11’);
 (vii) Select month(‘2010-02-07’);