SQL ! SQL - DATABASE DATABASE JUST CHANGE THE CODES A BIT

PART B QUESTION 1 CREATE TABLE OCCURENCE( OCCURENCEID NUMBER (6), OCC_DATE DATE, OCC_PLACE VARCHAR2 (100), OCC_START_TIME TIMESTAMP, OCC_FINISH_TIME TIMESTAMP ); CREATE TABLE OCCURENCE_EXERCISE( OCCEXID NUMBER (4), EXCERCISENO VARCHAR2 (4 CHAR), OccuranceID NUMBER (4), REPS NUMBER (10), ATTEMPT1 NUMBER (10), ATTEMPT2 NUMBER (10), ATTEMPT3 NUMBER (10), CONDITION VARCHAR2 (30 CHAR) ); CREATE TABLE EXERCISE( EXERCISENO VARCHAR (6), EXERCISE_DESCRIPTION VARCHAR2 (50 CHAR), EXERCISETYPE VARCHAR2 (25 CHAR) ); QUESTON 2 INSERT INTO OCCURENCE_EXERCISE VALUES (9001, '001A' , '001' , 8 ,15 , 15, 15 ,'Light'); INSERT INTO OCCURENCE_EXERCISE VALUES (9002, '002A' , '001' , 8 ,70 , 75, 70 ,'Medium'); INSERT INTO OCCURENCE_EXERCISE VALUES (9003, '003A' , '002' , 12 ,90 , 95, 90 ,'Heavy'); INSERT INTO OCCURENCE_EXERCISE VALUES (9004, '004A' , '003' , 12 ,200 , 200, 200 ,'Medium'); INSERT INTO OCCURENCE_EXERCISE VALUES (9005, '006A' , '003' , 8 ,110 , 110, 115 ,'Heavy'); INSERT INTO OCCURENCE_EXERCISE VALUES (9006, '005A' , '004' , 10 ,20 , 25, NULL ,'Medium'); INSERT INTO OCCURENCE_EXERCISE VALUES (9007, '001A' , '004' , 8 ,10 , 12, 10 ,'Medium'); INSERT INTO OCCURENCE_EXERCISE VALUES (9008, '002A' , '005' , 8 ,85 , 90, 115 ,'Heavy'); PART B QUESTION 3 SELECT * FROM ( SELECT EXERCISENO , SUM(ATTEMPT1*REPS + ATTEMPT2*REPS +ATTEMPT3*REPS) AS TOTAL_WEIGHT_LIFTED FROM OCCURENCE_EXERCISE GROUP BY EXERCISENO ORDER BY CASE WHEN TOTAL_WEIGHT_LIFTED IS NULL THEN 1 ELSE 0 END, TOTAL_WEIGHT_LIFTED DESC) WHERE ROWNUM = 1 PART B QUESTION 4 SELECT DISTINCT o.EXERCISENO, ex.EXERCISEDESCRIPTION FROM OCCURENCE_EXERCISE o ,EXERCISE ex WHERE o.EXERCISENO=ex.EXERCISENO AND (ATTEMPT1 IS NULL OR ATTEMPT2 IS NULL OR ATTEMPT3 IS NULL)