Based on the below student table write the SQL commands for the following
questions
NO Name
Course
Mark
Grade
Class
1
Kannan
Computer
80
B
12 A
2
Kumar
Commerce 89
A
12 C
3
Arun
Biology
65.5
C
12 B
4
Vivek
Commerce 92
A
11 C
5 Sudha Biology 75 B 11 B
6 Balaji Computer 61.5 C 11 A
7
Ravi
Commerce 78.3
B
12 C
8
Kumar
Computer
96
A
11 A
(a) Select all the non-biology student from the above table
(b) List the name of all class 11 student in the mark order
(c) To count number of student with Grade ‘A’
(d) To insert new student record in the above table and fill the entire column
with values.
Answers
Answered by
0
Answer:
Answer is 12 11 10 8 7 12
Explanation:
Pls Make me brainlist
Similar questions