Update teacher
Set
Salary = 66000
Where teach_id = 13;
Update teacher
Set
name = 'Victor B. Dalko'
Where teach_id = 13;
Update teacher
Set
salary = salary * 1.2
Where teach_id = 11;
Update grade
Set
status = 'done'
Where subject_id = 13;
Update grade
Set
term_id = '201704'
Where grade_varchar =
'does not meet expectations';
Update grade
Set
term_id = 201702
Where subject_id = 11;
Update student
Set
student_name = 'Pablo Gomez III'
Where student_id = 13;
Update student
Set
creditsearned = '9.0'
Where student_id = 14;
Update student
Set
dob = '1992-09-09'
Where student_id = 13;
Delete from 'teacher'
WHERE name = 'Sara Sikes' ;
Delete from teacher where
salary < 30000 ;
Delete from teacher
where teach_id < 11 ;
Delete from grade
where term_id < 201702 ;
Delete from grade
where student_id > 19 ;
Delete from grade
where subject_id > 14 ;
Delete from student
where student_name = 'Mike Miller' ;
Delete from student
where creditsearned < 1 ;
Delete from student
where creditsearned = 8 ;
Found at https://parkland1-my.sharepoint.com/:w:/r/personal/sdow3_stu_parkland_edu/_layouts/15/Doc.aspx?sourcedoc=%7B9ADBB784-B847-4BF0-BE34-1D06976E186B%7D&file=Module%201_%20CSC176%20Data%20Systems_Sharon%20Dow%20102318.docx&action=default&mobileredirect=true
Found at https://parkland1-my.sharepoint.com/:w:/r/personal/sdow3_stu_parkland_edu/_layouts/15/Doc.aspx?sourcedoc=%7B9ADBB784-B847-4BF0-BE34-1D06976E186B%7D&file=Module%201_%20CSC176%20Data%20Systems_Sharon%20Dow%20102318.docx&action=default&mobileredirect=true