Write an SQL statement that
a. Returns the Ids of all seniors in the table Student
b. Deletes all seniors from Student
c. Promotes all juniors in the table Student to seniors
a. ```
SELECT S.Id
FROM Student
WHERE S.Status = ’senior’
```
b. ```
DELETE
FROM Student S
WHERE S.Status = ’senior’
```
c. ```
UPDATE Student S
SET S.Status = ’senior’
WHERE S.Status = ’junior’
```
You might also like to view...
The chsh -l command is used in the following session to display the locations of all the shells available on our system.
What will be an ideal response?
In this exercise, you will learn how to use the Solution Explorer window’s Auto Hide feature by perform- ing the following steps:
The operating system that a computer uses sometimes is called which of the following?
A. base B. platform C. index D. boot system
You recently created several new user accounts in the Sales OU and configured them with the appropriate group membership, logon scripts, and printer access. Except for one new sales employee, all employees are actively using the account. The remaining employee will be using the account within the next two weeks. What is best practice for the remaining unused account?
A. Leave the account active since it will be unused for only two weeks. B. Delete the account and re-create it when the employee is ready to use it. C. Remove the account membership to all groups. D. Disable the account until the employee is ready to use it.