View difference between Paste ID: iu3BuykU and X4r2f1ej

 CREATE TABLE patient
 (
-patient_id VARCHAR(255) PRIMARY KEY,
+
-p_name VARCHAR(255),
+
-sex VARCHAR(255),
+cost NUMBER
-admission_date DATE,
+
-alzheimer_diagnosis VARCHAR(255)
+
 INSERT INTO patient
 VALUES ('T001','P1500',55);
-CREATE TABLE treatment
+
 INSERT INTO patient
 VALUES ('T003','P1500',null);
 
-drug VARCHAR(255),
+INSERT INTO patient
-dcost NUMBER,
+VALUES ('T004','P1500',57);
-adm_time DATE,
+
-consultant VARCHAR(255),
+INSERT INTO patient
-FOREIGN KEY (patient_id) REFERENCES patien (patient_id)
+VALUES ('T005','P9500',null);
-);
+
 INSERT INTO patient
 VALUES ('T006','P4000',81);
 
 INSERT INTO patient
 VALUES ('T007','P4000',82);
 
 SELECT Nvl(cost,0),PATIENT_ID,TREATEMENT_ID
 FROM patient;
 
 SELECT *
 FROM patient
 WHERE cost < 60 OR cost >= 60;
 
 
 SELECT lower(drug)
 FROM treatment;
 
 SELECT avg(salary)
 FROM STAFF;
 
 SELECT sum(salary)
 FROM staff;
 
 SELECT max(t_time),min(t_time)
 FROM treatment;
 
 SELECT count(t_time)
 FROM treatment;
 
 SELECT count(drug)
 FROM treatment
 where drug is not null;