LIVE Course for free

Rated by 1 million+ students
Get app now
JEE MAIN 2023
JEE MAIN 2023 TEST SERIES
NEET 2023 TEST SERIES
NEET 2023
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
43.8k views
in Computer by (72.1k points)

Consider the following tables SCHOOL and ADMIN and answer this question :

Write SQL statements for the following:

1. To display TEACHERNAME, PERIODS of all teachers whose periods are more than 25.

2. To display all the information from the table SCHOOL in descending order of experience.

3. To display DESIGNATION without dupli¬cate entries from the table ADMIN.

4. To display TEACHERNAME, CODE and corresponding DESIGNATION from tables SCHOOL and ADMIN of Male teachers.

1 Answer

0 votes
by (89.4k points)
selected by
 
Best answer

1. SELECT TEACHERNAME, PERIODS FROM SCHOOL WHERE PERIODS>25:

2. SELECT * FROM SCHOOL;

3. SELECT DISTINCT DESIGNATION FROM ADMIN;

4. SELECT TEACHERNAME.CODE 

DESIGNATION FROM 

SCHOOL.CODE = ADMIN.CODE 

WHERE GENDER = MALE;

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

...