Write SQL queries for TRAINERTIDTNAMECITYHIREDATESALARY101SUNAINA MU

1.	Write SQL queries for TRAINERTIDTNAMECITYHIREDATESALARY101SUNAINA MUMBAI1998-10-1590000102ANAMIKADELH1994-12-2480000103DEEPTICHANDIGARG2001-12-21 82000104MEENAKSHI DELHI2002-12-25 78000105RICHAMUMBAI 1996-01-1295000106MANIPRABHACHENNAI2001-12-1269000COURSECIDCNAMEFEESSTARTDATETIDC201AGDCA120002018-07-02101C202ADCA150002018-07-15103C203DCA100002018-10-01102C204DDTP90002018-09-15 104C205DHN200002018-08-01101C206O LEVEL180002018-7-25105(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’;
Answer» (i) DISTINCT TID 101 103 102 104 105 *(ii) TIDCOUNT()MIN(FEES) 101 2 12000 (iii) COUNT()SUM(FEES)* 4 65000

Write SQL queries for TRAINERTIDTNAMECITYHIREDATESALARY101SUNAINA MUMBAI1998-10-1590000102ANAMIKADELH1994-12-2480000103DEEPTICHANDIGARG2001-12-21 82000104MEENAKSHI DELHI2002-12-25 78000105RICHAMUMBAI 1996-01-1295000106MANIPRABHACHENNAI2001-12-1269000COURSECIDCNAMEFEESSTARTDATETIDC201AGDCA120002018-07-02101C202ADCA150002018-07-15103C203DCA100002018-10-01102C204DDTP90002018-09-15 104C205DHN200002018-08-01101C206O LEVEL180002018-7-25105(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’;

Answer»

(i) DISTINCT TID

101

103

102

104

105

(ii) TIDCOUNT(*)MIN(FEES)

101 2 12000

(iii) COUNT(*)SUM(FEES)

4 65000

Discussion

No Comment Found

Related InterviewSolutions

What is meant by coagulation of a colloidal solution? Describe briefly any three methods by which coagulation of lyophobic sols can be carried out.
What is meant by coagulation of a colloidal solution? Name any method by which coagulation of lyophobic sols can be carried out.
Classify the following contraceptives measures into different methods of birth control.(1) Vasectomy(2) tubectomy(3) Saheli(4) Diaphragms(5) Cervical caps(6) Condoms
An object is placed at a distance of 30 cm from a concave lens of focal length 15 cm. List four characteristics (nature, position etc) of the image formed by the lens.
Explain the following: (i) CH3COOH is a weak acid. (ii) Propene undergoes addition reaction. (iii) The gas stoves have inlets for air.
Accumulation of harmful chemicals in our body can be avoided. Explain how this can be achieved ?
State the changes that take place in the uterus when: (i) Implantation of embryo has occurred (ii) Female gamete/egg is not fertilised
A hollow metal sphere of radius 5cm is charged such that the potential on its surface is 10V. What is the potential at the centre of the sphere?
Ms. Raveena Sen is an IT expert and a freelancer. She recently used her skills to access the Admin password for the network server of Super Dooper Technology Ltd. and provided confidential data of the organization to its CEO, informing him about the vulnerability of their network security. Out of the following options (i) to (iv), which one most appropriately defines Ms. Sen? Justify the reason for your chosen option: (i) Hacker (ii) Cracker (iii) Operator (iv) Network Admin
An elevator descends into a mine shaft at the rate of 6 m/min. If the descent starts from 10 above the ground level, how long will it take to reach -350 m?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment