So im trying to do the statement and im still cant figure out how to answer the questions

8. SQL statement (i dont know if its true or not but hey its incomplete so do please help me)

SELECT COUNT (DocID) FROM DUTY WHERE DateDiagnose

9. SQL Statement i really dont know how to update a date ... like seriously i dont know how

UPDATE DUTY SET Diagnosis ='Stomach Cancer', DateDiagnose = WHERE PatID = 444;

8. Display total number of doctors who are on duty for each ward in June 2020. (5 marks) ANSWER: Paste your screenshot of SQL and OUTPUT here 9. Update the diagnosis into Stomach Cancer and diagnosis date change to 01/01/2021 for Patient ID = 444. All Access Obje... PatID BedNo Click to Add Search... Tables Query1 Query2 Query3 2 PATIENT E DUTY DocID Date Diagnose - WardID 101 1/5/2020 C10 102 10/5/2020 C5 103 1/5/2020 0 222 444 333 Diagnosis 16 Tumor in stomach 24 Epilepsy 11 Epilepsy 0 E DOCTOR DUTY 0 E PATIENT FE WARD Queries