Count data and eliminating duplication in SQL (ORACLE)

Question

i have data in this table.

..... ....

so i want the output to look like table

what is the SQL for that?

Answer 1

Simple. GROUP BY and COUNT.

select
    customer_no,
    items,
    count(*) "COUNT"
from your_table
group by customer_no,
    items;