Oracle | SQL Assessment | Complete Solutions & Tips | Handling NULL Values | Campus Assessment

Question 1: ORACLE: Organizational Reporting Structure Problem Statement Write the SQL query to get the first name as FIRSTNAME, the last name as LASTNAME, and the title as TITLE of the Employee who does not report to any manager. REPORTSTO signifies the Employee Id of the Employee's Manager. Output Column Name: FIRSTNAME, LASTNAME, TITLE Specifications: Input Table vs Column Names: Employee (EmployeeID, LastName, FirstName, Title, ReportsTo, BirthDate, HireDate, Address, City, State, Country, PostalCode, Phone, Fax, Email) Table Descriptions Employee Name ...