Please explain what the code and explain your solution

SQL (ANSI) 2 Min. 57 Sec. Remaining Progress Sample Query Line 1 SELECI vendor name, orders Line 2 FROM vendors Line 3 WHERE distribution center_unicipality- Line 4 (SELECT municipality from distribution_centers Line 5 WHERE municipality LIKE 'Sani Line 6 AND state-"CA Line 7 ORDER BY orders DESC Question How do you modify the sample query above to avoid an error if the subquery returns more than one row? Change Line 1 to: SELECT DISTINCT vendor name, orders Choice 1 Change Line 5 to: WHERE MAX (municipality) LIKE 'San&' Choice Change Line 4 to: (SELECT DISTINCr municipality FROM distribution_centers Change Line 7 to: ORDER BY distribution_center_municipality, orders DESC Choice 4 Change Line 3 to: WHERE distribution_center municipality-ANY Choice5 Record AnswerSQL (ANSI), Question 22 of 40 Copyright 2010 Brainbench All Rights Reserved