Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table transaction_detail_mv (
    individual_id int,
    dollar_value_us int,
    quantity int,
    transaction_number int,
    sku varchar(10),
    txn_date date,
    brand_org_code varchar(5),
    is_merch int,
    currency_code varchar(5),
    line_item_amt_type_cd varchar(1)
);
insert into transaction_detail_mv values(1, 10, 30,567,903633, to_date('01-02-2019','DD-MM-YYYY'), 'BRAND', 1, 'USD', 'S');
1 rows affected

insert into transaction_detail_mv values(1, 20, 30,567,123767, to_date('01-02-2019','DD-MM-YYYY'), 'BRAND', 1, 'USD', 'S');
1 rows affected

insert into transaction_detail_mv values(2, 11,80,910,363635, to_date('11-02-2019','DD-MM-YYYY'), 'BRAND', 1, 'USD', 'S');
1 rows affected

insert into transaction_detail_mv values(3, 9, 62,855,678364, to_date ('12-02-2019','DD-MM-YYYY'), 'BRAND', 1, 'USD', 'S');
1 rows affected

SELECT
* FROM transaction_detail_mv


INDIVIDUAL_ID
DOLLAR_VALUE_US
QUANTITY
TRANSACTION_NUMBER
SKU
TXN_DATE
BRAND_ORG_CODE
IS_MERCH
CURRENCY_CODE
LINE_ITEM_AMT_TYPE_CD


1
10
30
567
903633
01-FEB-19
BRAND
1
USD
S

1
20
30
567
123767
01-FEB-19
BRAND
1
USD
S

2
11
80
910
363635
11-FEB-19
BRAND
1
USD
S

3
9
62
855
678364
12-FEB-19
BRAND
1
USD
S


select Dollar_Range, count(distinct individual_id) AS INDIV,sum(quantity) AS QTY
from (select *,
             (case when dollar_value_us < 10 then 'below $10'
                   when dollar_value_us < 20 then '$10 - $20'
                   when dollar_value_us < 30 then '$20 - $30'
                   when dollar_value_us < 40 then '$30 - $40'
                   when dollar_value_us < 50 then '$40 - $50'
                   else '$50 - above'
            end) as dollar_range
      from transaction_detail_mv 
     ) t
group by dollar_range
order by min(dollar_value_us);
ORA-00923: FROM keyword not found where expected

INDIVIDUAL_ID	DOLLAR_VALUE_US	QUANTITY	TRANSACTION_NUMBER	SKU	TXN_DATE	BRAND_ORG_CODE	IS_MERCH	CURRENCY_CODE	LINE_ITEM_AMT_TYPE_CD
1	10	30	567	903633	01-FEB-19	BRAND	1	USD	S
1	20	30	567	123767	01-FEB-19	BRAND	1	USD	S
2	11	80	910	363635	11-FEB-19	BRAND	1	USD	S
3	9	62	855	678364	12-FEB-19	BRAND	1	USD	S