Create a list of years that appear on both the top_critic_years_more_than_four_games table and the top_user_years_more_than_four_games table. -- Select the year results that appear on both tables
时间: 2024-01-14 15:03:55 浏览: 65
sem.rar_The Count
Sure, here's the SQL query to create a list of years that appear on both the top_critic_years_more_than_four_games table and the top_user_years_more_than_four_games table:
```
SELECT year
FROM top_critic_years_more_than_four_games
WHERE year IN (
SELECT year
FROM top_user_years_more_than_four_games
);
```
This query uses a subquery to select the years that appear in both tables, and then returns the list of years that meet this condition. Let me know if you have any other questions!
阅读全文