Напредни извештаи од базата (SQL и складирани процедури)

Најпродавана конфигурација

select * 
from project."Configuration" as c
order by c.quantity_sold desc
limit 1;

Најпосакувани продукти од одредена конфигурација

select c."name", sum(p.quantity_sold) as prodadeno
from project."Configuration" as c
join project.config_contains_product as ccp on ccp.config_id = c.config_id
join project.product as p on p.prod_id = ccp.prod_id
group by c."name"
order by prodadeno desc
limit 1;

10 најпродавани продукти

select * 
from project.product as p
order by p.quantity_sold desc
limit 10;

Најпопуларен производ во wishlists на корисниците

select p."name" as Product, p.description as Description
from project.product as p
join(
        select ptw.prod_id, count(ptw.prod_id) as cnt
        from project.product_to_wishlist as ptw
        group by ptw.prod_id
) as pw on p.prod_id = pw.prod_id
group by p."name", p.description, pw.cnt
order by pw.cnt desc
limit 1;