SQL Set Operators - UNION , UNION ALL, INTERSECT, MINUS - Day16

@LearnWithRD0529

TABLE SCRIPTS:
---------------------------
CREATE TABLE property1 (
property1_id INT,
property1_name VARCHAR(255),
property1_type VARCHAR(50),
property1_value DECIMAL(10, 2)
);

CREATE TABLE property2 (
property2_id INT,
property2_name VARCHAR(100),
property2_type VARCHAR(50),
property2_value DECIMAL(10, 2)
);

CREATE TABLE property3 (
id INT,
name VARCHAR(200),
type VARCHAR(50),
value DECIMAL(10, 2)
);

CREATE TABLE property4 (
id char(2),
name VARCHAR(255),
type VARCHAR(50),
value DECIMAL(10, 2)
);

---------------------------------------
INSERT SCRIPTS
--------------------------------------
-- Inserting the first property record
INSERT INTO property1 (property1_id, property1_name, property1_type, property1_value)
VALUES (1, 'Cozy Cottage', 'Residential', 250000.00);
INSERT INTO property1 (property1_id, property1_name, property1_type, property1_value)
VALUES (2, 'City View Penthouse', 'Residential', 1500000.00);
INSERT INTO property1 (property1_id, property1_name, property1_type, property1_value)
VALUES (3, 'Luxury Condo', 'Residential', 850000.00);
INSERT INTO property1 (property1_id, property1_name, property1_type, property1_value)
VALUES (3, 'Luxury Condo', 'Residential', 850000.00);

-- Inserting the second property record
INSERT INTO property2 (property2_id, property2_name, property2_type, property2_value)
VALUES (11, 'Downtown Office Space', 'Commercial', 750000.00);
INSERT INTO property2 (property2_id, property2_name, property2_type, property2_value)
VALUES (22, 'Office Building on Main Street', 'Commercial', 1250000.00);
INSERT INTO property2 (property2_id, property2_name, property2_type, property2_value)
VALUES (30, 'Industrial Warehouse', 'Industrial', 500000.00);
INSERT INTO property2 (property2_id, property2_name, property2_type, property2_value)
VALUES (40, 'Warehouse with Loading Dock', 'Industrial', 650000.00);
-- Inserting the third property record
INSERT INTO property3 (id, name, type, value)
VALUES (10, 'Beachfront Villa', 'Vacation Home', 1200000.00);
INSERT INTO property3 (id, name, type, value)
VALUES (20, 'Mountain Cabin Retreat', 'Vacation Home', 350000.00);
INSERT INTO property3 (id, name, type, value)
VALUES (30, 'Industrial Warehouse', 'Industrial', 500000.00);
INSERT INTO property3 (id, name, type, value)
VALUES (40, 'Warehouse with Loading Dock', 'Industrial', 650000.00);
-- Inserting the fourth property record
INSERT INTO property4 (id, name, type, value)
VALUES ('p1', 'Beachfront Villa', 'Vacation Home', 1200000.00);
INSERT INTO property4 (id, name, type, value)
VALUES ('p2', 'Cozy Cottage', 'Residential', 250000.00);

Видео SQL Set Operators - UNION , UNION ALL, INTERSECT, MINUS - Day16 канала Learn with RD