Fewpal
0 votes
416 views
in Information Technology by (47.4k points)
closed by

Consider a table SALESMAN with the following data:

SNOSNAMESALARYBONUSDATE OF JOIN
A01Beena Mehta3000045.2329-10-2019
A02K. L. Sahay5000025.3413-03-2018
B03Nisha Thakkar3000035.0018-03-2017
B04Leela Yadav80000NULL31-12-2018
C05Gautam Gola20000NULL23-01-1989
C06Trapti Garg7000012.3715-06-1987
D07Neena Sharma5000027.8918-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

1 Answer

+1 vote
by (46.2k points)
selected by
 
Best answer

alternative answer

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...