Practical Related Questions:(write step by step command)
CREATE BELOW TABLE
CREATE TABLE empl (month INT, emp VARCHAR(15), dept VARCHAR(15), salary
INT);
INSERT INTO empl VALUES
(1, "Oliver", "HR", 9000),
(1, "George", "IT", 8000),
(3, "Harry", "HR", 20000),
(6, "Jack", "IT", 110123),
(6, "Jacob", "SALES", 3000),
(12, "Noah", "SALES", 101000),
(12, "Charlie", "IT", 123456);
1.Count total no of Employee
2. Find the lowest salaries in each dept
3. Find month-wise maximum salaries
4. Find the sum all employee salaries
5. Find the average of salaries in each dept
