Looking for Query Help

1

Please help to write the query

2

DDL, Sample data?

3

Im my SQL We have couple of database tables, we want to compare and update in a new table the unique data. How to write for this in query? Sample you can select your data