besök: 1
färg: #e2e8f0
-- Skriv din SQL-kod här
CREATE TABLE Departments (
DepartmentID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
DepartmentName CHAR(50),
Location CHAR(50)
);
INSERT INTO Departments (DepartmentName, Location)
VALUES
("IT", "Stockhom"),
("HR","Göteborg"),
("Finance","Malmö");
SELECT * FROM Customers;
SELECT * FROM Products
WHERE Price > 200;
SELECT FirstName,LastName,BirthDate FROM Employees;
SELECT * FROM Orders
WHERE OrderDate>"1997-01-01";
SELECT CustomerName,City FROM Customers
WHERE City="Rio de Janeiro";
SELECT ProductName,Unit FROM Products
WHERE Unit LIKE "%pies%";
SELECT * FROM Orders
ORDER BY OrderDate DESC
LIMIT 5;
UPDATE Shippers
SET Phone="1234567890"
WHERE ShipperName="Speedy Express"
UPDATE Customers
SET Address="Main Street 456"
WHERE CustomerId=10;
DELETE FROM Products
WHERE ProductId=60;
DELETE FROM Customers
WHERE Country="Germany";
SELECT MAX(Price) FROM Products;
SELECT AVG(Price) FROM Products;
-- Skriv din SQL-kod här
-- 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
-- Skriv din SQL-kod här
-- Skriv din SQL-kod här
-- Skriv din SQL-kod här
-- Skriv din SQL-kod här
Använd tabellerna Customers, Orders, OrderDetails och Products.
-- Skriv din SQL-kod här
-- Skriv din SQL-kod här
-- Skriv din SQL-kod här