SQL-如何在查询表被另一个表连接后命名并保存它？

I am trying to practice using Microsoft SQL Server Management Studio 2014 on my own and I seem to have trouble understanding how to name and save a table after it has been joined by another table. I tried to find similar examples online, but they were either not helpful or they created an error with my code.I am trying to practice using Microsoft SQL Ser