SQL-for-Data-Analysis/SQLIntermediate6_Aliasing.sql at main · eminsin/SQL-for-Data-Analysis · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
/*******

Aliasing

*******/


SELECT *
FROM SQLTutorial.dbo.EmployeeDemographics

SELECT FirstName AS FName
FROM SQLTutorial.dbo.EmployeeDemographics

SELECT FirstName FName
FROM SQLTutorial.dbo.EmployeeDemographics

SELECT FirstName + ' ' + LastName AS FullName
FROM SQLTutorial.dbo.EmployeeDemographics

SELECT AVG(Age) AS AVGAge
FROM SQLTutorial.dbo.EmployeeDemographics

SELECT *
FROM SQLTutorial.dbo.EmployeeDemographics AS Demo

SELECT Demo.EmployeeID
FROM SQLTutorial.dbo.EmployeeDemographics AS Demo

SELECT *
FROM SQLTutorial.dbo.EmployeeDemographics AS Demo
JOIN SQLTutorial.dbo.EmployeeSalary AS Sal
ON Demo.EmployeeID = Sal.EmployeeID

SELECT Demo.EmployeeID, Sal.Salary
FROM SQLTutorial.dbo.EmployeeDemographics AS Demo
JOIN SQLTutorial.dbo.EmployeeSalary AS Sal
ON Demo.EmployeeID = Sal.EmployeeID

SELECT Demo.EmployeeID, Demo.FirstName, Demo.LastName, Sal.JobTitle, Ware.Age
FROM SQLTutorial.dbo.EmployeeDemographics AS Demo
LEFT OUTER JOIN SQLTutorial.dbo.EmployeeSalary AS Sal
ON Demo.EmployeeID = Sal.EmployeeID
LEFT OUTER JOIN SQLTutorial.dbo.WareHouseEmployeeDemographics AS Ware
ON Demo.EmployeeID = Ware.EmployeeID