Naming Confliction
Column name for the following query, and NationalIdNumber column in database is NationalIDNumber
Page No. 194
SELECT JobTitle, NationalIdNumber, YEAR(BirthDate) AS BirthYear
FROM HumanResources.Employee
the right code with some replacement and Capitalization
SELECT Title, NationalIDNumber, YEAR(BirthDate) AS BirthYear
FROM HumanResources.Employee
|
