Question

Consider the following Student table:-
ID Name Deptt Hiredate Category Gender Salary
1 Tanya
SST 1994-03-17 TGT F
30000
2 Abhishek ART 1990-02-12 PRT M 25000
3 Sanjana ENG 1980-05-16 PGT F
65000
4 Vishwajeet ENG 1989-10-16 TGT M 40000
5 Aman
HINDI 1990-01-08 PRT M 30000
6 Pritam
MATH 1985-07-09 PRT M 35000
7 Raj
SC 1994-04-12 TGT M 30000
a)Write the following queries:-
i) To display all information about teachers of Female PGT Teachers.
ii) To list names, departments and date of hiring of all the teachers in descending
order of date of joining.
iii)Add a column BONUS of decimal datatype with size 8.2.
b)Give outputs:-
i)SELECT * FROM Student WHERE Name LIKE 'A%' and Salary > 25000;
ii)SELECT Name, Deptt FROM Student WHERE Salary BETWEEN 25000 and​

Answer 1

jdjdjcjvivuduusujdjcjvivuduusufubufuudud

qjjsjfuxujaj DG ha ha ha ha yrs wen eh us eh yes eh us eh HD eh

Explanation:

हेलो हेलो