Description : 1. To display Names of Patients, TESTID and Test names for those Patients who were admitted -Technology
Last Answer : SQL commands for the given statements :(i) SELECT NAME, TESTID, TESTNAME FROM PATIENT, TESTWHERE PATIENT. TESTID = TEST. TESTID AND DTADMIT BETWEEN 01-DEC-2017' AND '15-DEC-2017' ;(ii) SELECT NAME, TESTNAME, COST ... NAME LIKE '% Sharma %' ;(iii) UPDATE TEST SET COST = COST +50 WHERE COST < 200 ;