UNION

Question

FIDE wants to hold a major chess tournament and has decided to include players from the Norway Chess and Tata Steel tournaments.

Table NorwayChess:

player country birthyear rating
Magnus Carlsen Norway 1990 2863
Alireza Firouzja Iran 2003 2728
Levon Aronian Armenia 1982 2767
Fabiano Caruana USA 1992 2828
Jan-Krzysztof Duda Poland 1998 2757
Aryan Tari Norway 1999 2633

Table TataSteel:

player country birthyear rating
Magnus Carlsen Norway 1990 2863
Wesley So USA 1993 2770
Van Foreest Jorden Netherlands 1999 2671
Fabiano Caruana USA 1992 2828
Yu Yangyi China 1994 2709

Write a query to merge 'NorwayChess' and 'TataSteel' tables. Then order the merged table by 'Rating' in descending order and show the final table of participants.

need help please

Answer 1

SELECT * FROM norwaychess
Union
SELECT * FROM tatasteel
ORDER BY rating DESC

Answer 2

select player , country , birthyear , rating from NorwayChess
union

select player , country , birthyear , rating from Tatasteel

order by rating desc

Answer 3

You have redundant data in your table. Did the task specify what to do with redundant data?