-- create table project a
CREATE TABLE PROJECTS_A(
	PROJECT_ID	INT,
	PROJECT_NAME	VARCHAR(50)
)

-- load some dummy data
INSERT INTO PROJECTS_A VALUES (1,'INVESTMENTS PROFIT ANALYSIS')
INSERT INTO PROJECTS_A VALUES (2,'AUDITING 2020')
INSERT INTO PROJECTS_A VALUES (3,'PURGE INACTIVE USERS')
INSERT INTO PROJECTS_A VALUES (4,'MIGRATION TO CLOUD')

-- check your data
SELECT * FROM PROJECTS_A

-- create table project b
CREATE TABLE PROJECTS_B(
	PROJECT_ID	INT,
	PROJECT_NAME	VARCHAR(50)
)

-- load some dummy data
INSERT INTO PROJECTS_B VALUES (1,'INVESTMENTS PROFIT ANALYSIS')
INSERT INTO PROJECTS_B VALUES (2,'AUDITING 2020')
INSERT INTO PROJECTS_B VALUES (3,'PURGE INACTIVE USERS')
INSERT INTO PROJECTS_B VALUES (4,'MIGRATION TO CLOUD')
INSERT INTO PROJECTS_B VALUES (5,'KNOWLEDGE TRANSFER')
INSERT INTO PROJECTS_B VALUES (6,'TRAININGS 2021')

-- check your data
SELECT * FROM PROJECTS_B

-- What exist in PROJECT_A and do not exist in PROJECT_B
SELECT *
  FROM PROJECTS_A A
WHERE NOT EXISTS (SELECT 1
					FROM PROJECTS_B B
				   WHERE A.PROJECT_ID   = B.PROJECT_ID
				     AND A.PROJECT_NAME = B.PROJECT_NAME)

-- What exist in PROJECT_A and exists in PROJECT_B
SELECT *
  FROM PROJECTS_A A
WHERE EXISTS (SELECT 1
					FROM PROJECTS_B B
				   WHERE A.PROJECT_ID   = B.PROJECT_ID
				     AND A.PROJECT_NAME = B.PROJECT_NAME)

-- What exist in PROJECT_B and donīt exist in PROJECT_A
SELECT *
  FROM PROJECTS_B B
WHERE NOT EXISTS (SELECT 1
					FROM PROJECTS_A A
				   WHERE A.PROJECT_ID   = B.PROJECT_ID
				     AND A.PROJECT_NAME = B.PROJECT_NAME)

-- EXCEPT
-- What exist in PROJECT_A and do not exist in PROJECT_B
SELECT *
  FROM PROJECTS_B
EXCEPT
SELECT *
  FROM PROJECTS_A

-- What exist in PROJECT_B and donīt exist in PROJECT_A
SELECT *
  FROM PROJECTS_A
EXCEPT
SELECT *
  FROM PROJECTS_B

-- What exist in PROJECT_A and exists in PROJECT_B
SELECT *
  FROM PROJECTS_A
INTERSECT
SELECT *
  FROM PROJECTS_B