Answer to Question #145179 in Databases | SQL | Oracle | MS Access for Nisha davare

Question

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

Answer 1

Dear Nisha davare, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order