Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

roysched Table

The roysched table is a lookup table. Publishers use it for calculating author royalties, which are based on sales. As the sales increase, the royalty rate also increases. The title_id column is fixed-length character, the low and high ranges are integers, and royalty is a decimal value. The nonunique index is on title_id, and there are 51 rows.

						title_id  lorange    hirange     royalty
not null  null       null        null
rstidind ======== =========== =========== ======= BU1032 0 5000 .10 BU1032 5001 50000 .12 PC1035 0 2000 .10 PC1035 2001 4000 .12 PC1035 4001 50000 .16 BU2075 0 1000 .10 BU2075 1001 5000 .12 BU2075 5001 7000 .16 BU2075 7001 50000 .18 PS9999 0 50000 .10 PS2091 0 1000 .10 PS2091 1001 5000 .12 PS2091 5001 50000 .14 PS2106 0 2000 .10 ...