Zadania SQL 03.03.2021

Zadanie 1.
SELECT Employee.FirstName, Employee.LastName, Department.Name
FROM Employee
INNER JOIN Department ON Employee.DepartmentID = Department.ID;

Zadanie 2.
SELECT Employee.FirstName, Employee.LastName, Department.Name
FROM (Employee
INNER JOIN Department ON Employee.DepartmentID = Department.ID);
WHERE DepartmentID IS NULL;

Zadanie 3.
SELECT Employee.FirstName, Employee.LastName
FROM (Employee
INNER JOIN Department ON Employee.DepartmentID = Department.ID);
WHERE Department.Name = "IT";

Zadanie 4.
SELECT Employee.FirstName, Employee.LastName, Employee.Salary, Department.Name
FROM (Employee
INNER JOIN Department ON Employee.DepartmentID = Department.ID);
WHERE Department.Name = "__" AND Employee.Salary < 2000;

Zadanie 5.
SELECT Employee.FirstName, Employee.LastName, Department.Name
FROM (Employee
INNER JOIN Department ON Employee.DepartmentID = Department.ID);
ORDER BY Employee.Salary DESC LIMIT 1;

Zadanie 6.
SELECT DISTINCT Department.Name
FROM (Department
INNER JOIN Employee ON Employee.DepartmentID = Department.ID);
WHERE Employee.DepartmentID IS NOT NULL OR Employee.DepartmentID != 0;

Zadanie 7.
SELECT Department.Name, Employee.FirstName, Employee.LastName
FROM (Employee
INNER JOIN Department ON Employee.DepartmentID = Department.ID);
ORDER BY Department.Name ASC;

Zadanie 8.
SELECT Department.Name, Employee.FirstName, Employee.LastName
FROM Employee
INNER JOIN Department ON Employee.ID = Department.ManagerID;

Zadanie 9.
SELECT Department.Name, Employee.FirstName, Employee.LastName
FROM Employee
INNER JOIN Department ON Employee.ID = Department.ManagerID;

Zadanie 10.
SELECT Department.Name
FROM Department
INNER JOIN Employee ON Employee.ID != Department.ManagerID;

Zadanie 11.
SELECT Department.Name
FROM Department
INNER JOIN Employee ON Employee.DepartmentID != Department.ID;

Zadanie 12.
SELECT Department.Name, City.Name
FROM Department
INNER JOIN City ON Department.CityID = City.ID;

Zadanie 13.
SELECT Employee.FirstName, Employee.LastName, Department.Name, City.Name
FROM ((Employee
INNER JOIN Department ON Employee.DepartmentID = Department.ID)
INNER JOIN City ON Department.CityID = City.ID);

Zadanie 14.
SELECT Employee.FirstName, Employee.LastName, Department.Name, City.Name
FROM ((Employee
INNER JOIN Department ON Employee.DepartmentID = Department.ID)
INNER JOIN City ON Department.CityID = City.ID);
WHERE Employee.FirstName LIKE "J%" AND City.ID = "Warsaw";

Zadanie 15.
SELECT Employee.FirstName, Employee.LastName
FROM ((Employee
INNER JOIN Department ON Employee.DepartmentID = Department.ID);
INNER JOIN City ON Department.CityID = City.ID);
WHERE LEFT(Employee.FirstName, 1) = LEFT(City.Name, 1);

Zadanie 16.
SELECT Employee.FirstName, Employee.LastName
FROM Employee
INNER JOIN Department ON Employee.ID != Department.ManagerID;