How to Create One Table From Another Database Table in SQL Server

SELECT * FROM EMP;
GO

SELECT * INTO EMP
FROM [HRDB].[dbo].[EMPLOYEES]
GO

SELECT * FROM EMP;

USE HRDB;
GO

SELECT [CustomerKey], [FirstName],[LastName], [Gender],[EmailAddress] , [YearlyIncome]
into CUSTOMER
FROM [AdventureWorksDW2017].[dbo].[DimCustomer]
WHERE Gender = 'M';
GO

SELECT * FROM CUSTOMER;
GO