Teachoo Sample Paper - Computer Science Class 12

CBSE Class 12 Sample Paper for 2023 Boards →
Computer Science - Class 12
Solutions to CBSE Sample Paper - Computer Science Class 12

Question 27 (i) - Teachoo Sample Paper - Computer Science Class 12 - Solutions to CBSE Sample Paper - Computer Science Class 12

Last updated at April 16, 2024 by

Consider the table STUDENT given below and write the output of the SQL queries that follow.

SID

SNAME

MARKS

GRADE

SECTION

101

RAVI

85

A

1

102

PRIYA

90

A

2

103

RAJU

75

B

1

104

ANITA

80

B

2

105

RANI

70

C

1

106

RAHUL

65

C

2

107

RAMESH

95

A

1

108

PREETI

60

D

2

(i) SELECT AVG(MARKS) FROM STUDENT WHERE GRADE = "A";

Answer:

Answer by student

The output of the SQL query is:

AVG(MARKS)

90

Detailed answer by teachoo

The rest of the post is locked. Join Teachoo Black to see the full post.

Join Now
Go Ad-free
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo