Hello firends i have register tabel and in this i have following fields like
r_id , f_name , l_name , isactive , pkg
in pkg field value has 1,2,3,4 and in this i want to find out percentage of like how many user has pkg value 1 and 2 and 3 and 4 i use following query but it is not work for me
SELECT COUNT(*) as cnt ,SUM(r_id) as sumSales ,AVG(r_id)*100 as avgSales
FROM reg where pkg=1
Aucun commentaire:
Enregistrer un commentaire