SQL>
SQL> CREATE TABLE products(
2 product_id NUMBER(6),
3 name VARCHAR2(50),
4 subcategory VARCHAR2(50),
5 category VARCHAR2(50),
6 pack_size VARCHAR2(30),
7 price NUMBER(8,2),
8 min_price NUMBER(8,2)
9 );
Table created.
SQL>
SQL>
SQL> select category, subcategory, name, price
2 from products
3 where price > 100
4 order by category, subcategory, name;
no rows selected
SQL> drop table products;
Table dropped.