/* SQL Fundamentals SELECT ... FROM */ /* Show teams */ select teamid, team_name from teams; /* List students */ select stdid, stdfname, stdlname from students; /* List all columns in teams */ select * from teams; /* List departments in AdventureWorks */ Select DepartmentID, Name, GroupName From AdventureWorks2008.HumanResources.Department; /* List shift data AdventureWorks */ Select ShiftID, Name, StartTime, EndTime From AdventureWorks2008.HumanResources.Shift; /* Count students */ select count(*) from students; /* Count employee records in AW */ select count(*) from AdventureWorks2008.HumanResources.Employee;