use product schema
Display product ID for ordered products whose quantity in the inventory is greater than 250. (You are not allowed to use JOIN for this question.)
En Relational_4 (Untitled_1) BS311_212834.DEPARTMENT DBS311_212834. JOB_HISTORY * DEPARTMENT_ID NUMBER (4) "EMPLOYEE_ID NUMBER (6 DEPARTMENT_NAME VARCHAR2 (30 BYTE) START_DATE DATE MANAGER_ID NUMBER (6) " END_DATE DATE LOCATION_ID NUMBER (4) " JOB_ID AR2 (10 BYTE) DEPT_ID_PK (DEPARTMENT_ID) DEPARTMENT_ID NUMBER (4 DEPT_MGR_FK (MANAGER_ID) JHIST_EMP_ID_ST_DATE_PK (EMPLOYEE_ID, START_DATE) DEPT_ID_PK (DEPARTMENT_ID JHIST_DEPT_FK (DEPARTMENT_ID) DEPT_LOCATION_IX (LOCATION_ID) JHIST_EMP_ID_ST_DATE_PK (EMPLOYEE_ID, START_DATE) DBS311_212834.LOCATION * LOCATION_ID NUMBER (4) STREET_ADDRESS VARCHAR2 (40 BYTE) POSTAL_CODE VARCHAR2 (12 BYTE) DBS311_212834.EMPLOYEE " CITY VARCHAR2 (30 BYTE) EMPLOYEE_ID NUMBER (6) STATE_PROVINCE VARCHAR2 (25 BYTE) FIRST_NAME VARCHAR2 (20 BYTE) COUNTRY_ID CHAR (2 BYTE) " LAST_NAME VARCHAR2 (25 BYTE) LOC_ID_PK (LOCATION_ID J * EMAIL VARCHAR2 (25 BYTE) PHONE NUMBER VARCHAR2 (20 BYTE) LOG_CITY_IX (CITY) " HIRE_DATE DATE LOC_COUNTRY_IX (COUNTRY_ID) JOB ID VARCHAR2 (10 BYTE) LOC_ID_PK (LOCATION_ID SALAR NUMBER (8,2) LOC_STATE_PROVINCE_IX (STATE_PROVINCE) COMMISSION_PCT NUMBER (2,2) MANAGER ID NUMBER (6) DEPARTMENT_ID NUMBER (4) DBS311_212834. JOB_GRADE EMP_EMAIL_UK (EMAIL) * GRADE CHAR (1 BYTE) EMP_EMP_ID_PK (EMPLOYEE_ID) * LOWEST_SAL NUMBER (8,2) EMP_DEPT_FK (DEPARTMENT_ID) " HIGHEST_SAL NUMBER (8,2) EMP_MANAGER_FK (MANAGER_ID) JOBGRADES_GRADE_PK (GRADE) EMP_DEPARTMENT_IX (DEPARTMENT_ID) JOBGRADES_GRADE_PK (GRADE) EMP_EMAIL_UK (EMAIL) EMP_EMP_ID_PK (EMPLOYEE_ID) JOB_ID DBS311_212834.COUNTRYv1 EMP_MANAGER_IX (MANAGER_ID) COUNTRY_ID CHAR (2 BYTE) EMP_NAME_IX (LAST_NAME, FIRST_NAME) COUNTRY_NAME VARCHAR2 (40 BYTE) REGION_ID NUMBER COUNTRY_C_ID_PK (COUNTRY_ID)Connections Orade Connections +. DBS211 . DBS311 Tables (Filtered) COUNTRY COUNTRY _ID COUNTRY _NAME REGION ID DEPARTMENT DEPARTMENT _ID DEPARTMENT_NAME MANAGER _ID LOCATION_ID EMPLOYEE EMPLOYEE ID FIRST_NAME LAST_NAME EMAIL PHONE NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT _ID -.HE JOB_GRADE GRADE LOWEST_SAL HIGHEST _SAL JOB_HISTORY EMPLOYEE _ID START_DATE END_DATE JOB_ID DEPARTMENT_ID -.HELOCATION LOCATION_ID STREET_ADDRESS POSTAL_CODE CITY STATE_PROVINCE COUNTRY _ID Reports All Reports +).P Analytic View Reports +)... Data Dictionary Reports +).P Data Modeler Reports +).P OLAP Reports +).(3 TimesTen Reports +).(F User Defined Reports
