# CustomerMaster

Address1:
5102 VOSSOR RD(M-42) MACRUNASRAUNT DIVAS


# SQLStrings

SQL:
SELECT TOP 25 Region, Customer_Name, Sum(Revenue) AS Sales INTO 1 FROM PvTblFeed GROUP BY Region, Customer_Name HAVING (((Region)="North"));


SQL:
INSERT INTO 1 ( Region, Customer_Name, Sales ) SELECT TOP 25 Region, Customer_Name, Sum(Revenue) AS Sales FROM PvTblFeed GROUP BY Region, Customer_Name HAVING ((([Region])="South"));


SQL:
INSERT INTO 1 ( Region, Customer_Name, Sales ) SELECT TOP 25 Region, Customer_Name, Sum(Revenue) AS Sales FROM PvTblFeed GROUP BY Region, Customer_Name HAVING ((([Region])="West"));


SQL:
INSERT INTO 1 ( Region, Customer_Name, Sales ) SELECT TOP 25 Region, Customer_Name, Sum(Revenue) AS Sales FROM PvTblFeed GROUP BY Region, Customer_Name HAVING ((([Region])="Midwest"));


SQL:
SELECT [Job_Code]INTO [tblJobCodes]FROM [Employee_Master] GROUP BY [Job_Code]


SQL:
INSERT INTO [tblJobCodes] ( [Job_Code] ) SELECT 'PPL' AS NewCode FROM [Employee_Master] GROUP BY 'PPL'


SQL:
UPDATE [tblJobCodes] SET [Job_Code] = 'PPL1' WHERE [Job_Code]='PPL'


SQL:
DELETE * FROM [tblJobCodes] WHERE [Job_Code]='PPL1'


