Simple Query Assignment
1. Find the OrderDate and ShipperName from the order that was made by customer
named Thomas Hardy.
Query:
SELECT Orders.OrderDate, Shippers.ShipperName
FROM Orders
JOIN Customers ON Orders.CustomerID = Customers.CustomerID
JOIN Shippers ON Orders.ShipperID = Shippers.ShipperID
WHERE Customers.ContactName = 'Thomas Hardy';
Result:
2. Get the employee born in January, sort by their name
Query:
SELECT FirstName, LastName, BirthDate
FROM Employees
WHERE MONTH(BirthDate) = 1
ORDER BY LastName, FirstName;
