sql questions for practice code example
Example 1: sql queries questions
SELECT SUBSTRING(Address, 1, CHARINDEX('(',Address)) FROM EmployeeInfo;
Example 2: practice sql queries
Select FIRST_NAME AS WORKER_NAME from Worker;
Example 3: sql queries practice
Select * from Worker where FIRST_NAME like '_____h';
Example 4: sql queries questions
SELECT E.EmpFname, E.EmpLname, P.EmpPosition
FROM EmployeeInfo E INNER JOIN EmployeePosition P ON
E.EmpID = P.EmpID AND P.EmpPosition IN ('Manager');