Question

15. Given the following table :
Table : STUDENT
No.
Name
Stipend
Stream
AvgMark
Grade
Class
Karan
1
400.00
78.5
B
12B
2
450.00
89.2
A
11C
Divakiar
Divya
Medical
Commerce
Commerce
Humanities
3
300.00
C С
120
68.6
73.1
4
Arun
350.00
B
120
5
Sabina
500.00
Nonmedical
90.6
A
11A
6
John
400.00
Medical
75.4
B
12B
7
Robert
250.00
Humanities
64.4
С
11A
8
Rubina
450.00
Nonmedical
88.5
A
12A
9
Vikas
500.00
Nonmedical
92.0
A
12A
10
Mohan
300.00
Commerce
67.5
C С
12C
Give the output of following SQL statements :
(1) SELECT MIN(AvgMark) FROM STUDENT WHERE AvgMark < 75;
(ii) SELECT SUM(Stipend) FROM Student WHERE Grade = 'B';
(iii) SELECT AVG(Stipend) FROM Student WHERE Class = '12A';
(iv) SELECT COUNT(DISTINCT) FROM Student ;
దేవరక​

Answer 1

Answer:

15. Given the following table :

Table : STUDENT

No.

Name

Stipend

Stream

AvgMark

Grade

Class

Karan

1

400.00

78.5

B

12B

2

450.00

89.2

A

11C

Divakiar

Divya

Medical

Commerce

Commerce

Humanities

3

300.00

C С

120

68.6

73.1

4

Arun

350.00

B

120

5

Sabina

500.00

Nonmedical

90.6

A

11A

6

John

400.00

Medical

75.4

B

12B

7

Robert

250.00

Humanities

64.4

С

11A

8

Rubina

450.00

Nonmedical

88.5

A

12A

9

Vikas

500.00

Nonmedical

92.0

A

12A

10

Mohan

300.00

Commerce

67.5

C С

12C

Give the output of following SQL statements :

(1) SELECT MIN(AvgMark) FROM STUDENT WHERE AvgMark < 75;

(ii) SELECT SUM(Stipend) FROM Student WHERE Grade = 'B';

(iii) SELECT AVG(Stipend) FROM Student WHERE Class = '12A';

(iv) SELECT COUNT(DISTINCT) FROM Student ;

దేవరక