select year, ob2.factory_label, ob3.product_sku, qty_passed, qty_failed from (
assignment_4(# (select year, factory_key, product_key, qty_passed, qty_failed from (select a.*, b.manufacture_year as year, rank() over(partition by b.manufacture_year order by a.qty_passed desc, a.qty_failed) from manufacture_fact a inner join calendar_manufacture_dim b on a.manufacture_cal_key=b.manufacture_cal_key) manufacture_fact where rank<=3)) ob1 inner join factory_dim ob2 on ob1.factory_key = ob2.factory_key inner join product_dim ob3 on ob1.product_key = ob3.product_key;