(i) SELECT NAME, PATIENT.TESTID, TESTNAME
/*TEST.TESTID accepted*/
FROM PATIENT, TEST
WHERE PATIENT.TESTID = TEST.TESTID
AND DTADMIT BETWEEN ‘01-DEC-2017’ and ’15-DEC-2017’;
OR
SELECT NAME, PATIENT.TESTID,
TESTNAME
/*TEST.TESTID accepted*/
FROM PATIENT, TEST
WHERE PATIENT.TESTID = TEST.TESTID AND DTADMIT >=‘01-DEC-2017’and DTADMIT <= ’15-DEC-2017’;
OR
SELECT NAME,P.TESTID,TESTNAME /*T.TESTID accepted*/
FROM PATIENT P, TEST T
WHERE P.TESTID = T.TESTID AND DTADMIT BETWEEN ‘01-DEC-2017’ and ’15-DEC-2017’;
OR
SELECT NAME,P.TESTID,TESTNAME /*T.TESTID accepted*/
FROM PATIENT P, TEST T WHERE P.TESTID = T.TESTID
AND DTADMIT >= ‘01-DEC-2017’ and DTADMIT <= ’15-DEC-2017’;
(ii) SELECT NAME, TESTNAME, COST ½ FROM PATIENT, TEST
WHERE PATIENT.TESTID = TEST.TESTID AND Name LIKE ‘%Sharma%’;
OR
SELECT NAME, TESTNAME, COST
FROM PATIENT P, TEST T
WHERE P.TESTID = T.TESTID
AND Name LIKE ‘%Sharma%’;
OR
SELECT P.NAME, T.TESTNAME, T.COST
FROM PATIENT P, TEST T
WHERE P.TESTID = T.TESTID
AND Name LIKE ‘%Sharma%’;
(iii) UPDATE TEST
SET COST = COST+50.00
WHERE COST <200.00;