SQL Commands for Student Class Management
Uploaded by
sanaafreen1407SQL Commands for Student Class Management
Uploaded by
sanaafreen1407Common questions
Powered by AITo update a student's stipend to a new value based on their roll number, you can use the following SQL command: UPDATE CLASS SET STIPEND='new_value' WHERE ROLLNO='specific_roll_number' . For roll number 3, the command is UPDATE CLASS SET STIPEND='1250' WHERE ROLLNO='3'.
To arrange the CLASS table records in alphabetical order by student names, the SQL command is: SELECT *FROM CLASS ORDER BY NAME .
To update a student's subject in the CLASS table when the roll number is known, use the UPDATE statement. For example, to change the subject to 'BCA' for roll number 4, the SQL command is: UPDATE CLASS SET SUBJECT='BCA' WHERE ROLLNO='4' .
The query to show students' names and subjects with grades 'B' or 'C' is: SELECT *FROM CLASS WHERE GRADE='B' OR GRADE='C' . Filtering by grades can be significant for identifying students who are meeting certain performance thresholds, allowing educators to assess the effectiveness of teaching methods, provide additional support, or recognize achievements.
The command to retrieve students' names and roll numbers with average marks between 75 and 100 is: SELECT NAME, ROLLNO, SUBJECT FROM CLASS WHERE AVGMARK BETWEEN 75 AND 100 . This range can be useful for educators as it identifies students performing above average, allowing them to offer advanced opportunities or further motivation to maintain or improve performance.
To delete a student's record based on their roll number in the CLASS table, use the SQL DELETE statement. If the roll number is 2, the command is: DELETE FROM CLASS WHERE ROLLNO='2' .
To list the records of students whose second alphabet in their name is 'A', use the SQL LIKE pattern matching operator. The specific command is: SELECT *FROM CLASS WHERE NAME LIKE '_A%' .
Inserting a new student record into the CLASS table involves using the INSERT INTO statement. For example, to insert the following record: (6, 'JACK', 2800, 'HUMANITIES', 98, 'A'), you would use the SQL command: INSERT INTO CLASS VALUES (6, 'JACK', 2800, 'HUMANITIES', 98, 'A').
To display records of students securing marks more than 80 from a specific subject, such as 'NON-MEDICAL', the SQL statement is: SELECT *FROM CLASS WHERE AVGMARK>80 AND SUBJECT='NON-MEDICAL' .
To display the names and subjects of students with an average mark below 70, the SQL query to use is: SELECT NAME, SUBJECT FROM CLASS WHERE AVGMARK<70 .