Before we write any SQL we're going to need a database. For this challenge, we'll be using mySQL. At this point, we just want the data on our SQL Server, and we'll improve it later. Using details of ...
2 CREATE TABLE E2 USING EMPLOYEES TABLE WHICH WILL HAVE EMPLOYEE_ID , JOB_ID , SALARY COLUMNS ONLY. -> CREATE TABLE E2 AS SELECT EMPLOYEE_ID, JOB_ID, SALARY FROM EMPLOYEES; 3 CREATE TABLE E3 USING ...