Question

Consider a table SALESMAN with the following data:

SNO	SNAME	SALARY	BONUS	DATE OF JOIN
A01	Beena Mehta	30000	45.23	29-10-2019
A02	K. L. Sahay	50000	25.34	13-03-2018
B03	Nisha Thakkar	30000	35.00	18-03-2017
B04	Leela Yadav	80000	NULL	31-12-2018
C05	Gautam Gola	20000	NULL	23-01-1989
C06	Trapti Garg	70000	12.37	15-06-1987
D07	Neena Sharma	50000	27.89	18-03-1999

Write SQL queries using SQL functions to perform the following operations:

(a) Display salesman name and bonus after rounding off to zero decimal places.

(b) Display the position of occurrence of the string “ta” in salesman names.

(c) Display the four characters from salesman name starting from second character.

(d) Display the month name for the date of join of salesman 

(e) Display the name of the weekday for the date of join of salesman

Answer 1

alternative answer