Teachers TeachNo TeachName CourseNo DeptNo StartDate Salary 101 Kluger 101 10 20
ID: 3847156 • Letter: T
Question
Teachers
TeachNo
TeachName
CourseNo
DeptNo
StartDate
Salary
101
Kluger
101
10
20-Oct-2016
65000
102
Confucious
102
11
11-Jan-2017
73000
103
Crazer
101
10
15-Aug-2000
71000
104
Nutting
103
10
16-Aug-2007
52000
105
Brawler
104
11
20-Aug-2005
91000
106
Lazerk
107
12
20-Sep-2002
64000
107
Alienous
105
13
15-Aug-2001
79000
108
Asylant
106
13
15-Aug-2007
61000
109
fanatikal
102
11
20-Sep-2000
62000
110
Babyest
101
10
20-Aug-2003
67000
Looking for a couple SQL statements that pertain to the table above. I am using ORACLE.
1. List the teachername and courseno for courses taught by teachers whose last name start with the letter ‘C’
2. List all teachno, teacherNames, and courseno for courses they teach for teachers whose salary is above 70000.
3. How many departments do we have?
Teachers
TeachNo
TeachName
CourseNo
DeptNo
StartDate
Salary
101
Kluger
101
10
20-Oct-2016
65000
102
Confucious
102
11
11-Jan-2017
73000
103
Crazer
101
10
15-Aug-2000
71000
104
Nutting
103
10
16-Aug-2007
52000
105
Brawler
104
11
20-Aug-2005
91000
106
Lazerk
107
12
20-Sep-2002
64000
107
Alienous
105
13
15-Aug-2001
79000
108
Asylant
106
13
15-Aug-2007
61000
109
fanatikal
102
11
20-Sep-2000
62000
110
Babyest
101
10
20-Aug-2003
67000
Explanation / Answer
1.select TeachName,CourseNo from Teachers where TeachName LIKE ‘C%’;
The LIKE conditions indicate a test including design matching.whereas the correspondence administrator (=) precisely coordinates one character an incentive to another,the LIKE conditions match a part of one character an incentive to another via scanning the principal esteem for the example determined by the second.LIKE figures strings utilizing characters as characterized by the info character set.
2.SELECT teachno,teacherNames,courseno FROM from Teachers WHERE Salary > 70000;
3.1.SELECT DISTINCT DeptNo
FROM Teachers;
2.SELECT DeptNo,count(DeptNo)
FROM Teachers
GROUP BY DeptNo;
The SELECT Unmistakable articulation is utilized to return just particular distinctive values.inside a table,a section frequently contains many copy esteems and some of the time you just need to list the diverse unmistakable values.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.