Using ASC and DESC and join tables in SQL Server

Hi vereato,

Refer below query.

SQL

I have used following tables with the schema as below.

Also i have inserted few records in the tables.

CREATE TABLE [Actors]
(
    [Id] [int] NOT NULL PRIMARY KEY,
    [ActorName] [nchar](50) NOT NULL
)
GO
INSERT [Actors] ([Id], [ActorName]) VALUES (1, N'Jason Statham')
INSERT [Actors] ([Id], [ActorName]) VALUES (2, N'Bruce Lee')
INSERT [Actors] ([Id], [ActorName]) VALUES (3, N'Van Dame')
GO
 
CREATE TABLE [Movies]
(
    [Id] [int] NOT NULL PRIMARY KEY,
    [ActorId] [int] NOT NULL,
    [MovieName] [nchar](50) NOT NULL
)
GO
INSERT [Movies] ([Id], [ActorId], [MovieName]) VALUES (101, 1, N'The Transporter')
INSERT [Movies] ([Id], [ActorId], [MovieName]) VALUES (102, 1, N'Wrath of Man')
INSERT [Movies] ([Id], [ActorId], [MovieName]) VALUES (103, 2, N'Bruce Lee The Fighter')
INSERT [Movies] ([Id], [ActorId], [MovieName]) VALUES (104, 2, N'Bruce Lee The Myth')
INSERT [Movies] ([Id], [ActorId], [MovieName]) VALUES (105, 3, N'Kill them All')
INSERT [Movies] ([Id], [ActorId], [MovieName]) VALUES (106, 3, N'the Quest')
GO

/* ORDER BY MovieName Ascending. */
SELECT movie.MovieName
	,actor.ActorName
FROM [Movies] movie
INNER JOIN [Actors] actor ON actor.Id = movie.ActorId
ORDER BY movie.MovieName ASC

/* ORDER BY MovieName Descending. */
SELECT movie.MovieName
	,actor.ActorName
FROM [Movies] movie
INNER JOIN [Actors] actor ON actor.Id = movie.ActorId
ORDER BY movie.MovieName DESC

/* ORDER BY ActorName Ascending. */
SELECT movie.MovieName
	,actor.ActorName
FROM [Movies] movie
INNER JOIN [Actors] actor ON actor.Id = movie.ActorId
ORDER BY actor.ActorName ASC

/* ORDER BY ActorName Descending. */
SELECT movie.MovieName
	,actor.ActorName
FROM [Movies] movie
INNER JOIN [Actors] actor ON actor.Id = movie.ActorId
ORDER BY actor.ActorName DESC

Screenshot