Oracle Message QSM-02024 - no GROUP BY clause

ERRORno GROUP BY clause
CAUSEThe capability in question is not supported when the materialized view does not use a GROUP BY clause.
ACTIONRe-phrase the query to use a GROUP BY clause.