--
-- Dumping data for table `employees`

-- SELECT * FROM employees WHERE EmployeeID > 3 AND EmployeeID < 7;
-- SELECT * FROM employees ORDER BY EmployeeID DESC;
-- SELECT * FROM employees WHERE FirstName LIKE 'A%';
-- SELECT * FROM employees WHERE FirstName LIKE '_n%';
-- SELECT ProductID, SUM(Quantity) AS totale FROM order_details GROUP BY ProductID;
CREATE TABLE `orders` (
  `OrderID` int(11) NOT NULL,
  `CustomerID` int(11) DEFAULT NULL,
  `EmployeeID` int(11) DEFAULT NULL,
  `OrderDate` date DEFAULT NULL,
  `ShipperID` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`OrderID`, `CustomerID`, `EmployeeID`, `OrderDate`, `ShipperID`) VALUES
(10248, 90, 5, '1996-07-04', 3),
(10249, 81, 6, '1996-07-05', 1),
(10250, 34, 4, '1996-07-08', 2),
(10251, 84, 3, '1996-07-08', 1),
(10252, 76, 4, '1996-07-09', 2),
(10253, 34, 3, '1996-07-08', 2),
(10254, 14, 5, '1996-07-11', 2),
(10255, 68, 9, '1996-07-12', 3);

SELECT * FROM orders;