select categories.name,sum(amount) "sum"
from products
inner join categories on products.id_categories=categories.id
group by categories.name;
from products
inner join categories on products.id_categories=categories.id
group by categories.name;
URI SQL Solution 2609 Products by Categories - Solution in PostgreSQL
I am Md Abdullah Al Hasan. I have completed my graduation in Computer Science and Engineering from Jashore University of Science and Technology.
0 Comments:
Post a Comment