Question

list all columns of the resource table with a rate between $10 and $15 including the end points 10 and 15. Sort the result by rate.

Answer 1

Answer:

select * from resources

where rate between 10 and 15

order by rate (ASC|DESC)

Explanation:

On Chegg + SQL textbook

(Here we are using * keyword to fetch all the records from resource table and between operator is used to fetch values between two vaues(values included).

Order By clause is used to sort the values and ASC is used with order by clause to sort in ascending order and DESC is used to sort in Descending Order.

By default if we do not specify anything then it will take ASC.