Using NorthWind2020 select customers

CustomersNorthWind2020_customers.sql

SELECT Cust.CustomerIdentifier, 
       Cust.CompanyName, 
       Cust.ContactId, 
       CT.ContactTitle, 
       C.FirstName, 
       C.LastName, 
       Cust.Street, 
       Cust.City, 
       Cust.Region, 
       Cust.PostalCode, 
       Countries.[Name] AS CountryName, 
       Cust.CountryIdentifier, 
       Cust.Phone, 
       Cust.Fax, 
       Cust.ContactTypeIdentifier, 
       Cust.ModifiedDate
FROM Customers AS Cust
     INNER JOIN Contacts AS C ON Cust.ContactId = C.ContactId
     INNER JOIN ContactType AS CT ON Cust.ContactTypeIdentifier = CT.ContactTypeIdentifier
     INNER JOIN Countries ON Cust.CountryIdentifier = Countries.CountryIdentifier;