I need the answer in Microsoft SQL server.

Q6) For below DEPARTMENT table write a SQL query (query6.sql) so that repeated group names are shown with quotation symbol like in above desired output (15 points). DEPARTMENT Desired output D GroupName D GroupName 1 Research and Development 1 Research and Development 2 Research and Development 2 3 Sales and Marketing 3 Sales and Marketing 4 Sales and Marketing 4 5 Inventory Management 5 Inventory Management 6 Research and Development 6 Research and Development 7 Manufacturing 7 Manufacturing 8 Manufacturing 8 9 Executive General and Administration 9 Executive General and Administration 10 Executive General and Administration 10 11 Executive General and Administration 11 12 Quality Assurance 12 Quality Assurance 13 Quality Assurance 13 14 Executive General and Administration 14 Executive General and Administration 15 Inventory Management 15 Inventory Management 16 Executive General and Administration Executive General and Administration 16