PP-COMPUTERS 10 A-2020-21
Dashboard
My courses
PP-COMPUTERS 10 A-2020-21
21 September - 27 September
Assignment on SQL
Edit submission
Assignment on SQL
ASSIGNMENT ON SQL CLASS X
COMPUTER
Write the SQL commands on the basis of Teacher table
Table : TEACHER
No
Name
Age
Dept
DOJ
Salary
Sex
1
Jugal
34
Computer
10/01/97
12000
M
2
Sharmila
31
History
24/03/98
20000
F
3
Sandeep
32
Maths
12/12/96
30000
M
4
Sangeeta
35
History
01/07/99
40000
F
5
Rakesh
42
Maths
05/09/97
25000
M
6
Shyam
50
History
27/06/98
30000
M
7
Shiv Om
44
Computer
25/02/97
21000
M
8
Shalakha
33
Maths
31/07/97
20000
F
1. Create the above table.
2. Insert the records shown in the above table.
3. Display the structure of the table.
4. To view all table names.
5. To see all database names.
6. To display all records of teacher table.
7. To view records of teachers of ‘Maths’ department.
8. To get a report of teachers whose salary is above 20000.
9. To see the records of ‘Male’ teachers.
10. To display the records of teachers who have joined before ‘1/1/97’
Answers
Answered by
0
Answer:
destiny
32
economics
female
window xp
Similar questions