Making SQL statements

4. List Order IDs that has more than 4 quantities ordered per item. (Hint: Use Distinct to list unique Order IDs) 5. List the Customers who does not have a website 6. List the Customers who does have a website. 7. List Customer IDs who have ordered a product. 8. List Product IDs that are ordered. 9. List unique list prices for products 10. List Products with list prices 30. 120, 125, and 150 Table: | DEMO CUSTOMERS Column Data TypeLengthPrecision ScaleNullable CUSTOMERID NUMBER No UST FIRSTINAM VARCHAR2 VARCHAR2 CUST STREETLADDRESS1VARCHAR2 CUST STREET ADDRESS2VARCHAR2 20 20 60 60 0 CUST LAST NAME No -Yes UST CITY VARCHAR 30 es Yes CUST STATE VARCHAR2 CUST POSTAL CODEVARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 10 30 25 25 Yes Yes Yes Yes 2 Yes CUSTEMAIL - PHONE NUMBERT E NUMB ER2 VARCHAR210 URL CREDIT LIMT TAGS NUMBER VARCHAR2 4000 Table: DEMO ORDERS Column Data Type Length Precision Scale Nullable ORDER ID CUSTOMER ID ORDER TOTAL ORDER-TIMESTAMP USER NAME TAGS NUMBER NUMBER NUMBER TIMESTAMP(6) WITH LOCAL TIME ZONE VARCHAR2 VARCHAR2 No No 8 2 Yes 6 Yes Yes 11 100 4000 : .Yes Table: DEMO ORDER ITEMS Column Data Type Length Precision Scale Nullable ORDER ITEMID NUMBER ORDER ID PRODUCT ID NUMBER UNIT PRICE QUANTITY 0 No NUMBER - No - No 2 No 0 No NUMBER NUMBER Table DEMO PRODUCT INFO Data Type Length Precision ScaleNuliable PRODUCT.ID PRODUCT NAME PRODUCT DESCRIPTION VARCHAR2 CATEGORY PRODUCT AVAIL IST PRICE PRODUCT IMAGE NUMBER No VARCHAR2 50 Yes 2000 VARCHAR2 VARCHAR2 NUMBER BLOB VARCHAR2 VARCHAR2 30 2 Yes 4000 255 400 11 Yes MIMETYPE FILENAME IMAGE LAST UPDATE TAGS TIMESTAMPI6) WITH LOCAL TIME ZONE 6 Yes VARCHAR Table: DEMO TAGS Column Data Type Length Precision Scale Nullable ID NUMBER No TAG CONTENT IDNUMBER CONTENT TYPE VARCHAR2 CREATED CREATED BY UPDATED TIMESTAMP(6) WITH LOCAL TIME ZONE UPDATED, BYVARCHAR2 VARCHAR2 255 No 30 11 255 Yes TIMESTAMP(6) WITH LOCAL TIME ZONE 6 Yes VARCHAR2 6 Yes 255 Yes 1-8