KPMG | OA | SQL: Employee Designation Formatting

Question 1: SQL Coding - Employee Designation Problem Statement: Consider the Employee table: contains five columns: "Id", "Name", "Salary", "Designation" and "ExpInYears". Write a query to display the employee names in alphabetical order followed by the first letter of their designation enclosed in parentheses. Table Schema: Employee Column Type Id int Name varchar Salary int Designation varchar ExpInYears Decimal(3, 2) Sample Input: Id Name Salary Designation ExpInYears 101 Rajesh 13000 System Engg   102 Pritam 5000 System Engg   104 ...