Category : aggregate

SELECT category_id,product_size,category_name,SUM(product_quantity) AS total_quantity FROM tbl_categories_quantity (table-1) INNER JOIN tbl_categories USING (category_id) GROUP BY category_id,product_size The Above Code is working in a single table, and I want to Add the below code (2nd table) that does not work SELECT category_id,product_size, SUM(product_sell) AS total_sell FROM tbl_product_sell (table-2) GROUP BY category_id,product_size THANKS Advance Sourc..

Read more

{"name": "John", "district": 1, "light": 2}, {"name": "John", "district": 5, "light": 2}, {"name": "John", "district": 5, "light": 27}, {"name": "John", "district": 11, "light": 1}, {"name": "John", "district": 11, "light": 0}, {"name": "John", "district": 11, "light": 10}, {"name": "John", "district": 8, "light": 6}, {"name": "Mary", "district": 2, "light": 10}, {"name": "Nick", "district": 1, "light": 0}, {"name": ..

Read more