Electronics Dope

CLICK HERE TO GET FULL SOLUTIONS WITH OUTPUTS : HERE Tables used :- PRACTICALS AVAILABLE :- 1. Create the table Employee and Department. Insert data in a table 2. Insert data in the table Employee and Department. Simple Select 3. Display the details of all the employees. 4. Display the Salary, Zone, and Grade of all the employees. 5. Display the records of all the employees along with their annual salaries. The Salary column of the table contains monthly salaries of the employees. The new column should be given the name “Annual Salary”. Conditional Select using Where Clause 6. Display the details of all the employees who are below 30 years of age. 7. Display the names of all the employees working in North zone. 8. Display the salaries of all the employees of department 10. Using NULL 9. Display the details of all the employees whose Grade is NULL. 10. Display the details of all the employees whose Grade is not NULL. Using DISTINCT Clause 11. Display the...