Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In 2022 session, new students were admitted, and their information are displayed in the table below Table 2: New students 2.1 Write SQL query to
In 2022 session, new students were admitted, and their information are displayed in the table below Table 2: New students 2.1 Write SQL query to add the new students to the studentlist table and save the changes. (10 Marks) 2.2 Use the UPDATE keyword to change the year of admission of 'Peter Abe' to 2020. (3 Marks) 2.3 To improve the database management, you are tasked to add a new column "Age" into the Studentlist table. Implement the task using SQL query and specify the data type. (2 Marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started