SQL - Advanced Joins
Given tables
Products(product_id, price) and Discounts(min_price, max_price, discount_rate), what does this query return?SELECT p.product_id, d.discount_rate FROM Products p JOIN Discounts d ON p.price >= d.min_price AND p.price < d.max_price;
