Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
1.4k views
in Computer by (61.3k points)

Give the following relations

EMPL ( FirstName, LastName, Workdept, Empno, Educlevel, Jobcode, Salary, Bonus, hiredate)

Dept (Deptno, Deptname, Mgrno, Adurdept)

Statement for creating above table :

1.  List employee last name, work department and monthly salary for those in Services, Planning and Information center departments.

2.  List employee last name, work department, department number, and department name.

3.  Which employees earn more than their manager ?

4. List suppliers who supply only red parts.

1 Answer

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

1.  SELECT LastName, Workdept , Salary from EMPL WHERE Deptname IN ( ‘Services’, ‘Planning’, ‘Information center’);

2. SELECT LastName, Workdept , Deptno, Deptname from EMPL, Dept WHERE Empl.Deptno = Dept.Deptno ;

3. SELECT EmpName from EMPL, MANG WHERE empl.mgrid=mang.mgrid and EMPL.Salary > MANG.Salary ;

4. SELECT SupName from Supplier WHERE colour = ‘Red’ ; 

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

...