Code

Question 1

SELECT

Answer 1

SELECT CustomerID, CustomerName, CustomerAddress

FROM Customers

Question 2

SELECT + WHERE

Answer 2

SELECT OrderID, ProductID
FROM Orders
WHERE CustomerID = ‘C1’

Question 3

SELECT + JOIN

Answer 3

SELECT Customers.CustomerName, Orders.QuantityOrdered, Products.ProductName
FROM Customers JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
JOIN Products
ON Orders.ProductID = Products.ProductID

Question 4

VIEW + SELECT + WHERE

Answer 4

CREATE VIEW P1Orders AS
SELECT CustomerID, OrderID, Quantity
FROM Orders
WHERE ProductID = “P1”

Question 5

VIEW + SELECT + JOIN

Answer 5

CREATE VIEW CustomersProducts AS
SELECT Customers.CustomerName, Orders.QuantityOrdered, Products.ProductName
FROM Customers JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
JOIN Products
ON Orders.ProductID = Products.ProductID

Question 6

SELECT + ORDER BY

Answer 6

SELECT *
FROM MyTable
ORDER BY MyColumn1

Question 7

SELECT + MIN

Answer 7

SELECT MIN(MyColumn1)
FROM MyTable

Question 8

UPDATE + WHERE

Answer 8

UPDATE MyTable
SET MyColumn2 = ‘contoso’
WHERE MyColumn1 = 3

Question 9

DELETE

Answer 9

DELETE FROM MyTable

WHERE MyColumn2 = ‘contoso’

Question 10

INSERT

Answer 10

INSERT INTO MyTable(MyColumn1, MyColumn2, MyColumn3)

VALUES (99, ‘contoso’, ‘hello’)

Question 11

CREATE TABLE

Answer 11

CREATE TABLE MyTable
(
    MyColumn1 INT NOT NULL PRIMARY KEY,
    MyColumn2 VARCHAR(50) NOT NULL,
    MyColumn3 VARCHAR(10) NULL
);