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
16.1k views
in Computer by (72.1k points)

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

Give the output the following SQL queries :

1. Select Designation Count (*) From Admin Group By Designation Having Count (*) <2;

2. SELECT max (EXPERIENCE) FROM SCHOOL;

3. SELECT TEACHER FROM SCHOOL WHERE EXPERIENCE >12 ORDER BY TEACHER;

4. SELECT COUNT (*), GENDER FROM ADMIN GROUP BY GENDER;

1 Answer

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

(i)

VICE PRINCIPAL 01

(ii)

16

(iii)

UMESH
YASH RAJ

(iv) 

5 MALE
2 FEMALE

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

...