Relational Database Design and SQL

For each question, write the SQL statements required to generate the required results.

List all the information from the roysched table where the royalty is greater than or equal to 15 and less than or equal to 20, and the title id is BU1111, MC2222, or PS3333. Order the result set by the title id. The query should produce the result set listed below.

roysched_id title_id lorange hirange royalty

--------------- ----------- ---------- ---------- ----------

53 BU1111 12001 16000 16

54 BU1111 16001 20000 18

55 BU1111 20001 24000 20

61 MC2222 8001 12000 16

62 MC2222 12001 20000 18

63 MC2222 20001 50000 20

49 PS3333 15001 50000 16

(7 row(s) affected)