Back to Database Query Using Sql
Question 1 of 20
Random Informatics-practices - Database Query Using Sql Practice
20 randomly selected questions from Database Query Using Sql topics
Progress: 0%
Success Rate: 0%
Question 1
database-query-using-sql > querying-and-grouping
Consider the following tables:
Table: STUDENT
StudentID Name Class 1 Ankit 12 2 Priya 11 3 Rohan 12 4 Shreya 11 5 Rehan 12
Table: MARKS
| StudentID | Subject | Score |
|---|---|---|
| 1 | Mathematics | 85 |
| 2 | Physics | 78 |
| 3 | Chemistry | 88 |
| 4 | Biology | 81 |
| 6 | Computer Science | 93 |
Write appropriate SQL queries for the following:
I. List the names of students enrolled in Class 12, sorted in ascending order.
II. Display name of all subjects in uppercase where students scored more than 80 marks.
III. Display the names of students along with their subject and Score.
0 of 20 answered
Random Practice Session
Questions Answered0 / 20
Correct Answers0
Session Success Rate0%
Random Practice Ready! 🎯
Community Stats
Active Learners30
Questions Attempted597
Community Success Rate70%
Track Your Random Practice
Sign up to save your random practice progress and compare your performance across different categorys.