Create table `Vendors`
( `vend_country` VARCHAR (10) NOT NULL
, `vend_name` VARCHAR (20) NOT NULL
, `vend_state` VARCHAR(15) NOT NULL
, `cust_city` VARCHAR (10) NOT NULL
);
INSERT INTO `Vendors` VALUES
("USA", "JMUnion", "10", "1"),
("SS", "Cucumber", "1000", "2"),
("USSR", "CornJo", "12", "3"),
("CHINA", "Slave", "9999", "4"),
("IRELAND", "~pi", "3.49", "5")
;
SELECT UPPER(vend_name) AS vend_name_upcase
FROM Vendors
ORDER BY vend_name ASC;
Create table `Orders`
( `order_num` VARCHAR (10) NOT NULL
, `quantity` VARCHAR (20) NOT NULL
, `item_price` VARCHAR(15) NOT NULL
, `order_date` DATE NOT NULL
);
INSERT INTO `Orders` VALUES
("1", "100", "10", "2000-11-11"),
("2", "200", "1000", "2011-11-11"),
("3", "300", "12", "2004-06-17"),
("4", "400", "9999", "2004-04-04"),
("5", "900", "3.49", "2001-01-01")
;
SELECT order_num, DATEPART("yyyy",order_date) AS order_year
FROM Orders;
Telegram: DB developers channel