The first classification

According to supplier name, formula name and formula category, select supplier name, count, formula name, formula category, sum (formula unit price) and sum (quantity) from cpxxtb group.

second kind

If it is based on supplier statistics, it can be written as:

Select supplier name, count (name), total (menu unit price) and total (quantity) from the cpxxtb group by supplier name.

Final maximum total:

Select sum (menu unit price) and sum (quantity) from cpxxtb.

exceed