/* SQL Fundamentals SELECT ... FROM ... WHERE */ /* Show students on the SYSDES team. */ select std_teamID, stdfname, stdlname from students where std_teamID = 'SYSDES'; /* Show students on the DIGSOL team. No records are found. */ select std_teamID, stdfname, stdlname from students where std_teamID = 'DIGSOL'; /* Show all student data. Show that no one is on the DIGSOL team.*/ select * from students; /* Show students not majoring in information systems. */ select std_teamid, stdfname, stdlname from students where std_teamID <> 'ISYS'; /* Count how many Design Engineers there are at AW. */ select count(*) from AdventureWorks2008.HumanResources.Employee where jobtitle = 'Design Engineer'; /* Show the departments in the Quality Assurance group. */ Select DepartmentID, Name, GroupName From AdventureWorks2008.HumanResources.Department where GroupName = 'Quality Assurance';