-- Skriv din SQL-kod här
CREATE TABLE DEPARTMENTS (
DepartmentID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
DepartmentName varchar(50),
Location varchar(50)
);
-- Skriv din SQL-kod här
INSERT INTO Departments (DepartmentName, Location)
VALUES ('Finance', 'Malmö');
-- Skriv din SQL-kod här
SELECT * FROM Customers
-- Skriv din SQL-kod här
SELECT * FROM Products WHERE Price >= 200;
-- Skriv din SQL-kod här
SELECT FirstName, LastName, BirthDate FROM Employees;
-- Skriv din SQL-kod här
SELECT * FROM Orders WHERE OrderDate > "1997-1-1";
-- Skriv din SQL-kod här
SELECT CustomerName, City FROM Customers WHERE City = "Rio de Janeiro";
-- Skriv din SQL-kod här
SELECT ProductName, Unit FROM Products WHERE Unit LIKE "%pies%";
-- Skriv din SQL-kod här
SELECT * FROM Orders ORDER BY OrderDate DESC LIMIT 5;
-- Skriv din SQL-kod här
UPDATE Shippers SET Phone = "1234567890" WHERE ShipperName = "Speedy Express";
-- Skriv din SQL-kod här
UPDATE Customers SET Address = "Main Street 456" WHERE CustomerID = 10;
-- Skriv din SQL-kod här
DELETE FROM Products WHERE ProductId = 60;
-- Skriv din SQL-kod här
DELETE FROM Customers WHERE Country = "Germany";
-- Skriv din SQL-kod här
SELECT MAX(Price) FROM Products;
-- Skriv din SQL-kod här
SELECT AVG(Price) FROM Products;
-- Skriv din SQL-kod här
SELECT Orders.OrderId, Customers.CustomerName FROM Customers INNER JOIN Orders ON Customers.CustomerId=Orders.CustomerId;
-- Skriv din SQL-kod här
SELECT Products.ProductId, Categories.CategoryName FROM Products JOIN Categories ON Products.CategoryId=Categories.CategoryId;
-- Skriv din SQL-kod här
(Använd Orders, Customers, Employees och Departments.)
-- Skriv din SQL-kod här
-- Skriv din SQL-kod här
SELECT * FROM Products WHERE Price > (SELECT AVG(Price) FROM Products);
-- Skriv din SQL-kod här
SELECT FirstName, COUNT(OrderId) FROM Employees JOIN Orders ON Employees.EmployeeID=Orders.EmployeeID GROUP BY Employees.EmployeeID HAVING COUNT(Orders.EmployeeID) > 2;
-- Skriv din SQL-kod här
SELECT CustomerName, Products.Price * OrderDetails.Quantity AS TotalPrice FROM Customers
JOIN Orders ON Customers.CustomerId=Orders.CustomerId
JOIN OrderDetails ON Orders.OrderId=OrderDetails.OrderId
JOIN Products ON OrderDetails.ProductId=Products.ProductId
WHERE Country="USA" ORDER BY TotalPrice DESC
LIMIT 20;
-- Skriv din SQL-kod här
SELECT FirstName, LastName, BirthDate FROM Employees WHERE BirthDate BETWEEN '1950-1-1' and '1960-1-1';
-- Skriv din SQL-kod här
Använd tabellerna Customers, Orders, OrderDetails och Products.
-- Skriv din SQL-kod här
CREATE VIEW CustomerSpending AS
SELECT Customers.CustomerName, Products.Price * OrderDetails.Quantity AS TotalPrice
FROM Customers
JOIN Orders ON Customers.CustomerId=Orders.CustomerId
JOIN OrderDetails ON Orders.OrderId=OrderDetails.OrderId
JOIN Products ON OrderDetails.ProductId=Products.ProductId;
SELECT * FROM CustomerSpending
-- Skriv din SQL-kod här
-- Skriv din SQL-kod här