Working with AdventureWorks$2016$ database:

$1-$ Execute the following practice SELECT queries:

a$.$ Selecting all records in a table $($Employee$)$:

SELECT $*$ from HumanResources.Employee

b$.$ Selecting a subset of fields from a table:

SELECT LoginID,JobTitle,BusinessEntityID,NationalIDNumber

FROM HumanResources.Employee

c$.$ Sorting output of a query in ascending order:

SELECT LoginID,JobTitle,BusinessEntityID,NationalIDNumber

FROM HumanResources.Employee

ORDER BY NationalIDNumber ASC;

d$.$ Sorting output of a query in descending order:

SELECT LoginID,JobTitle,BusinessEntityID,NationalIDNumber

FROM HumanResources.Employee

ORDER BY NationalIDNumber DESC;

e$.$ Sorting output of a query using more than one column