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

Write SQL queries for 

TRAINER

TID TNAME CITY HIREDATE SALARY
101 SUNAINA  MUMBAI 1998-10-15 90000
102 ANAMIKA DELH 1994-12-24 80000
103 DEEPTI CHANDIGARG 2001-12-21  82000
104 MEENAKSHI  DELHI 2002-12-25  78000
105 RICHA MUMBAI  1996-01-12 95000
106 MANIPRABHA CHENNAI 2001-12-12 69000

COURSE

CID CNAME FEES STARTDATE TID
C201 AGDCA 12000 2018-07-02 101
C202 ADCA 15000 2018-07-15 103
C203 DCA 10000 2018-10-01 102
C204 DDTP 9000 2018-09-15  104
C205 DHN 20000 2018-08-01 101
C206 O LEVEL 18000 2018-7-25 105

(i) SELECT DISTINCT TID FROM COURSE;

(ii)  SELECT TID, COUNT(*), MIN(FEES) FROM COURSE GROUP BY TID HAVING COUNT(*)>1;

(iii)  SELECT COUNT(*), SUM(FEES) FROM COURSE WHERE STARTDATE< ‘2018-09-15’;

1 Answer

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

(i)  DISTINCT  TID

101

103

102

104

105

(ii)  TIDCOUNT(*)MIN(FEES)

101      2    12000

(iii)  COUNT(*)SUM(FEES)

4      65000

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

...