In mySQL:

For each step below, show the queries and the result

1) -- Type the following command to create an index and then execute the query

CREATEINDEXcnameidx ONdbo.customers(cname);

2) Type in the following 3 commands below: select the three commands and choose the icon Display Estimated Execution Plan.

SELECT*FROMdbo.CUSTOMERS WHEREcname='Basics';

SELECT*FROMdbo.CUSTOMERS;

SELECT*FROMdbo.PRODUCTS;

3) Type in the following command;

SELECT*FROMAdventureWorksDW2014_mg.dbo.DimCustomer;

SELECT*INTO[YOURDB].dbo.dimCustomers fromAdventureWorksDW2014_mg.dbo.DimCustomer;

4) Type in the following commands;

SELECT*FROMAdventureWorksDW2014_mg.dbo.DimEmployee;

SELECT*FROMAdventureWorksDW2014_mg.dbo.FactSalesQuota;

SELECT*FROMAdventureWorksDW2014_mg.dbo.DimEmployee

INNERJOIN AdventureWorksDW2014_mg.dbo.FactSalesQuota

ONAdventureWorksDW2014_mg.dbo.FactSalesQuota.EmployeeKey=AdventureWorksDW2014_mg.dbo.DimEmployee.EmployeeKey;

5) Highlight the three commands above (4) and choose the icon Display Estimated Execution Plan.