(ORACLE/SQL) Using this query developed below:

SELECT i.item_id , active_flag , cl.common_lookup_id AS "PRICE TYPE" , cl.common_lookup_type AS "PRICE DESC" , CASE WHEN (TRUNC(SYSDATE) - i.release_date) = 31 AND af.active_flag = 'N' THEN i.release_date ELSE i.release_date + 31 END AS "START DATE", CASE WHEN (active_flag='N') THEN TO_CHAR(TRUNC(i.release_date + 30), 'DD-MON-YY HH24:MI:SS') END AS "END DATE", CASE WHEN (TRUNC(SYSDATE) - TRUNC(i.release_date) > 30) AND (active_flag='N') AND (dr.rental_days = '1') THEN TO_CHAR(3) WHEN (TRUNC(SYSDATE) - TRUNC(i.release_date) > 30) AND (active_flag='N') AND (dr.rental_days = '3') THEN TO_CHAR(10) WHEN (TRUNC(SYSDATE) - TRUNC(i.release_date) > 30) AND (active_flag='N') AND (dr.rental_days = '5') THEN TO_CHAR(15) WHEN (TRUNC(SYSDATE) - TRUNC(i.release_date) > 30) AND (active_flag='Y') AND (dr.rental_days = '1') THEN TO_CHAR(1) WHEN (TRUNC(SYSDATE) - TRUNC(i.release_date) > 30) AND (active_flag='Y') AND (dr.rental_days = '3') THEN TO_CHAR(3) WHEN (TRUNC(SYSDATE) - TRUNC(i.release_date) > 30) AND (active_flag='Y') AND (dr.rental_days = '5') THEN TO_CHAR(5) WHEN (TRUNC(SYSDATE) - TRUNC(i.release_date)

Add the necessary columns to insert the values directly into the PRICE table. You need to create a PRICE_S sequence and call the sequence as a value in the SELECT-list. (HINT: You call the PRICE_S sequence like this PRICE_S.NEXVAL inside the SELECT-list.)

Table Name: PRICE Constraint Physical Size Data Column Name Type Reference Table Reference Column Type PRICE ID ITEM ID PRICE TYPE ACTIVE_FLAG PRIMARY KEY FOREIGN KEY ITEM FOREIGN KEY COMMON LOOKUP NOT NULL CHECK(Y, N') NOT NULL Integer Integer COMMON_LOOKUP ID Integer Maximum Maimum Maximum ITEM ID Text START_DATE END_DATE AMOUNT CREATED_BY CREATION DATE LAST UPDATED_BY LAST_UPDATE_DATE FOREIGN KEY NOT NULL FOREIGN KEY NOT NULL Date Date Integer Integer Date Integer Date Date Date Maimum Maximum Date Maximum Date SYSTEM_USER SYSTEM_USER_ID SYSTEM_USER SYSTEM_USER_ID Table Name: PRICE Constraint Physical Size Data Column Name Type Reference Table Reference Column Type PRICE ID ITEM ID PRICE TYPE ACTIVE_FLAG PRIMARY KEY FOREIGN KEY ITEM FOREIGN KEY COMMON LOOKUP NOT NULL CHECK(Y, N') NOT NULL Integer Integer COMMON_LOOKUP ID Integer Maximum Maimum Maximum ITEM ID Text START_DATE END_DATE AMOUNT CREATED_BY CREATION DATE LAST UPDATED_BY LAST_UPDATE_DATE FOREIGN KEY NOT NULL FOREIGN KEY NOT NULL Date Date Integer Integer Date Integer Date Date Date Maimum Maximum Date Maximum Date SYSTEM_USER SYSTEM_USER_ID SYSTEM_USER SYSTEM_USER_ID