Task: Text to Code
Input (English): Step 1: For each row in appellations table, find the corresponding rows in wine table.
Step 2: find Name of the results of step 1 whose Price less than 50 and County equals Monterey and County equals Sonoma
Output (English): SELECT T2.Name FROM appellations AS T1 JOIN wine AS T2 ON T1.Appelation = T2.Appelation WHERE T2.Price < 50 AND T1.County = "Sonoma" AND T1.County = "Monterey"