P Pre Langsql Cssfilehk1style Select Name From Instructor Where #258

</p> <pre><code class="language-sql"> Select name from instructor where salary <= 100000 and salary >= 90000;</code></pre> <p>This query can be replaced by which of the following ?

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 SQL: Queries, Constraints and Triggers - Basic SQL Operations - Quiz No.1.

 Select name from instructor where salary <= 100000 and salary >= 90000;

 Select name from instructor where salary between 90000 and 100000;

 Select name from employee where salary <= 90000 and salary>=100000;

 Select name from employee where salary between 90000 and 100000;

 Select name from instructor where salary between 100000 and 90000;