The where Clause (Cont.) SQL includes a between comparison operator Example:Find the loan number of those loans with loan amounts between $90,000and$100,000(that is,≥$90,000and≤$100,000) select loan number from loan where amount between 90000 and 100000 Database System Concepts,5th Edition,Oct 5,2006 3.14 @Silberschatz,Korth and SudarshanDatabase System Concepts, 5 3.14 ©Silberschatz, Korth and Sudarshan th Edition, Oct 5, 2006 The where Clause (Cont.) SQL includes a between comparison operator Example: Find the loan number of those loans with loan amounts between $90,000 and $100,000 (that is,  $90,000 and  $100,000) select loan_number from loan where amount between 90000 and 100000