sqlshite1

There are 2 tables:

PRODUCT [pcode, name, eprice, category, pieces, manufacturer]
COMPLAINT[ccode, product, date, buyer, level]

Give the following operations SQL form:
1, give a "description" field to the COMPLAINT table
2, pieces per manufacturer
3, decreas eprice by 10% where there is at least 5 complaints
4, list out  the number of  level 3 complaints per manufacturer
5, in which category there are the lowest number of complaints