roysched table

roysched is defined as follows:

create table roysched
title_id tid not null
    references titles(title_id),
lorange int null,
hirange int null,
royalty int null)

Its nonclustered index for the title_id column is defined as:

create nonclustered index titleidind
on roysched (title_id)

Table B-9 lists the contents of roysched:

Table B-9: roysched table

title_id

lorange

hirange

royalty

BU1032

0

5000

10

BU1032

5001

50000

12

PC1035

0

2000

10

PC1035

2001

3000

12

PC1035

3001

4000

14

PC1035

4001

10000

16

PC1035

10001

50000

18

BU2075

0

1000

10

BU2075

1001

3000

12

BU2075

3001

5000

14

BU2075

5001

7000

16

BU2075

7001

10000

18

BU2075

10001

12000

20

BU2075

12001

14000

22

BU2075

14001

50000

24

PS2091

0

1000

10

PS2091

1001

5000

12

PS2091

5001

10000

14

PS2091

10001

50000

16

PS2106

0

2000

10

PS2106

2001

5000

12

PS2106

5001

10000

14

PS2106

10001

50000

16

MC3021

0

1000

10

MC3021

1001

2000

12

MC3021

2001

4000

14

MC3021

4001

6000

16

MC3021

6001

8000

18

MC3021

8001

10000

20

MC3021

10001

12000

22

MC3021

12001

50000

24

TC3218

0

2000

10

TC3218

2001

4000

12

TC3218

4001

6000

14

TC3218

6001

8000

16

TC3218

8001

10000

18

TC3218

10001

12000

20

TC3218

12001

14000

22

TC3218

14001

50000

24

PC8888

0

5000

10

PC8888

5001

10000

12

PC8888

10001

15000

14

PC8888

15001

50000

16

PS7777

0

5000

10

PS7777

5001

50000

12

PS3333

0

5000

10

PS3333

5001

10000

12

PS3333

10001

15000

14

PS3333

15001

50000

16

BU1111

0

4000

10

BU1111

4001

8000

12

BU1111

8001

10000

14

BU1111

12001

16000

16

BU1111

16001

20000

18

BU1111

20001

24000

20

BU1111

24001

28000

22

BU1111

28001

50000

24

MC2222

0

2000

10

MC2222

2001

4000

12

MC2222

4001

8000

14

MC2222

8001

12000

16

MC2222

8001

12000

16

MC2222

12001

20000

18

MC2222

20001

50000

20

TC7777

0

5000

10

TC7777

5001

15000

12

TC7777

15001

50000

14

TC4203

0

2000

10

TC4203

2001

8000

12

TC4203

8001

16000

14

TC4203

16001

24000

16

TC4203

24001

32000

18

TC4203

32001

40000

20

TC4203

40001

50000

22

BU7832

0

5000

10

BU7832

5001

10000

12

BU7832

10001

15000

14

BU7832

15001

20000

16

BU7832

20001

25000

18

BU7832

25001

30000

20

BU7832

30001

35000

22

BU7832

35001

50000

24

PS1372

0

10000

10

PS1372

10001

20000

12

PS1372

20001

30000

14

PS1372

30001

40000

16

PS1372

40001

50000

18