In the university database, the instructor table contains columns ID$,$ name, dept$\_$name, and salary. Suppose you need to retrieve the names and salaries of instructors in the 'Comp. Sci.$\text{'}$ department who earn more than $$70,000.$ Which SQL statement would correctly achieve this?

Group of answer choices

SELECT name, salary FROM instructor WHERE dept$\_$name $=$ 'Comp. Sci.$\text{'}$ AND salary $>70000$;

SELECT name, salary FROM instructor WHERE dept$\_$name $=$ 'Comp. Sci.$\text{'}$ OR salary $>70000$;

SELECT name, salary FROM instructor WHERE dept$\_$name $=$ 'Comp. Sci.$\text{'}$ AND salary $>=70000$;

SELECT name FROM instructor WHERE dept$\_$name $=$ 'Comp. Sci.$\text{'}$ AND salary $>70000$;