Task: Text to Code
Input (English): Step 1: For each row in Ref_Product_Categories table, find the corresponding rows in Products table.
Step 2: find product_name, typical_buying_price of the results of step 1 whose product_category_description equals yellow
Output (English): SELECT T2.product_name , T2.typical_buying_price FROM Ref_Product_Categories AS T1 JOIN Products AS T2 ON T1.product_category_code = T2.product_category_code WHERE T1.product_category_description = "yellow"