Question: I have sent two questions please send answer within 1hr Merge the Above mentioned two tables and load all the data into Cust_Merge table. Create

I have sent two questions please send answer within 1hr
Merge the Above mentioned two tables and load all the data into Cust_Merge table. Create Cust_Merge table in your database by including column names given below: Columns of the Cust_Merge table:- Orderid, CustomerID, CustomerName, Address, City, PostalCode, Employeeld, OrderDate (50 Marks] 3. Create another two table with the same columns as per the Cust_Merge and give the Cust_Merge_Colombo and Cust_Merge_Gampaha names for each of the created tables. Based on the Cust_Merge table's data, load into Cust_Merge_Colombo table the customers who live in Colombo and load into Cust_Merge_Gampaha table the customers who live in Gampaha. [25 Marks] [Total Marks : 100] Merge the Above mentioned two tables and load all the data into Cust_Merge table. Create Cust_Merge table in your database by including column names given below: Columns of the Cust_Merge table:- Orderid, CustomerID, CustomerName, Address, City, PostalCode, Employeeld, OrderDate (50 Marks] 3. Create another two table with the same columns as per the Cust_Merge and give the Cust_Merge_Colombo and Cust_Merge_Gampaha names for each of the created tables. Based on the Cust_Merge table's data, load into Cust_Merge_Colombo table the customers who live in Colombo and load into Cust_Merge_Gampaha table the customers who live in Gampaha. [25 Marks] [Total Marks : 100]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
