CREATE TABLE nacar_ProductNorth(
	p_code NUMERIC (6,0) PRIMARY KEY NOT NULL,
	p_descript VARCHAR(25) NOT NULL,
	price NUMERIC (4,2) NOT NULL
);

INSERT INTO nacar_ProductNorth VALUES
(123456, 'Flashlight', 5.26),
(123457, 'Lamp', 25.15),
(123458, 'Box Fan', 10.99),
(213345, '9v battery', 1.92),
(254467, '100W bulb', 1.47),
(311452, 'Powerdrill', 34.99);

CREATE TABLE nacar_ProductSouth(
	p_code NUMERIC (6,0) PRIMARY KEY NOT NULL,
	p_descript VARCHAR(25) NOT NULL,
	price NUMERIC (5,2) NOT NULL
);

INSERT INTO nacar_ProductSouth VALUES
(345678, 'Microwave', 160.00),
(345679, 'Dishwasher', 500.00),
(123458, 'Box Fan', 10.99);

SELECT * FROM nacar_ProductNorth
UNION
SELECT * FROM nacar_ProductSouth
ORDER BY p_code ASC;

UPDATE tablename
SET toupdate = rightvalue
WHERE toupdate = wrongvalue;

SELECT * FROM nacar_ProductNorth
INTERSECT
SELECT * FROM nacar_ProductSouth
ORDER BY p_code ASC;

CREATE TABLE nacar_Sales2019_Quarter1(
	s_agent VARCHAR(10) NOT NULL,
	s_amount NUMERIC(8,2) NOT NULL
);

INSERT INTO nacar_Sales2019_Quarter1 VALUES
('Mike', 150000.25),
('Jon', 132000.75),
('Mary', 100000.00);

CREATE TABLE nacar_Sales2019_Quarter2(
	s_agent VARCHAR(10) NOT NULL,
	s_amount NUMERIC(8,2) NOT NULL
);

INSERT INTO nacar_Sales2019_Quarter2 VALUES
('Mike', 120000.25),
('Jon', 142000.75),
('Mary', 100000.00);

SELECT * FROM nacar_Sales2019_Quarter1
UNION
SELECT * FROM nacar_Sales2019_Quarter2
ORDER BY s_agent ASC;

SELECT * FROM nacar_Sales2019_Quarter1
UNION ALL
SELECT * FROM nacar_Sales2019_Quarter2
ORDER BY s_agent ASC;