Comments by brahim farhat (AAD) (Top 33 by date)

text.setText(R.string.name_of_string);

text.setText(R.string.valeu_of_string);

sum()

total() total()

total()

sum()

Cursor res_p;
		res_p = db.sumProfits();
		res_p.moveToNext();
		total_profits = res_p.getString(0);

 inmodorate

SELECT sa_id, 
       sa_date, 
       p_name, 
       cu_name, 
       sa_quantity, 
       sa_price, 
       sa_amount,
       Sum(pur_quantity * pur_price) 
               / Sum(pur_quantity)
        AS AVG_pur_Price 
FROM sales
JOIN products  ON products.p_id = sales.pro_id 
JOIN customers ON customers.cu_id = sales.cu_id
join purchases on purchases.pro_id=products.p_id
group by sa_id