السلام عليكم
اريد ان اسال ما الفرق بين ال queries التاليه
select product_id,year as first_year, quantity, price
from Sales
where(product_id, year) in (select product_id, min(year) from Sales group by product_id)
// تخرج حلا مختلف
select product_id,min(year) as first_year, quantity, price
from Sales
اري انه لا فرق