I also tried it with:

total [bigint] NULL

Results are the same 10 records

To get the 8 records, the select statement should look like this:

SELECT

st.SalesPersonID

, st.total

, RANK () OVER (PARTITION BY st.SalesPersonID

ORDER...

After correcting the script:

USE TEST

CREATE TABLE [dbo].[SalesTracking]
(
[SalesDate] [datetime] NULL,
[SalesPersonID] [int] NULL,
[CustomerID] [int] NOT NULL,
[PONumber] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[paid] [bit] NULL,
total [money] NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX...

Delving into a bit of "Rudolph the Red-Nosed Reindeer" trivia:

While the song does list all Nine of the reindeer, it does not specifically say that Santa used all of them...

Am I missing something here?

If I am reading this correctly, Microsoft is saying that an Update lock is converted to an Exclusive lock.

"Only one transaction can obtain an update (U)...

The implied multiplication comes into play because of the negative sign.

Think about Algebra

-100/-100*x can be written as -100/-100x

Algebra would solve this problem by multiplying the -100 and x first.

In our...

SQL reads from left to right

Example 16/4/4 is interpreted as (16/4)/4 = 1  instead of 16/(4/4)=16

SQL is using implied multiplication.

Multiplication is interpreted as having higher precedence than division, so that...

From

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-ver15

READ COMMITTED

Specifies that statements cannot read data that has been modified but not committed by other transactions. This prevents dirty reads. Data can be changed by other transactions between individual...

The correct answer is Movie
I had to add a Genre to the last record set and correct the syntax for the movie title [It's a Wonderful Life] to get...