SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Employee(EmployeeID INT(20) PRIMARY KEY, Name VARCHAR(55), Salary INT(20)); INSERT INTO Employee VALUE(100011, 'Smith', 50000) ; INSERT INTO Employee VALUE(100022, 'Bill', 94000); INSERT INTO Employee VALUE(100027, 'Sam', 70550); INSERT INTO Employee VALUE(100845, 'Walden', 80000); INSERT INTO Employee VALUE(115585, 'Erik', 60000); INSERT INTO Employee VALUE(1100070, 'Kate', 69000); DESCRIBE Employee; SELECT* FROM Employee; /* FIND ALL EMPLOYEE WHOSE SALARY IS MORE THAN AVERAGE SALARY OF ALL EMPLOYEE*/ SELECT E.EmployeeID, E.Name FROM Employee AS E INNER JOIN (SELECT AVG(E.Salary)) AS Vsal ON E.EmployeeID=Vsal.EmployeeID WHERE E.Salary>E.Vsal; SELECT AVG(Salary) FROM Employee; SELECT * FROM Employee GROUP BY EmployeeID HAVING AVG(Salary)>Salary; SELECT * FROM Employee WHERE Salary>'70591'; SELECT EmployeeID, Name, Salary FROM Employee GROUP BY EmployeeID HAVING AVG(Salary)>Salary; SELECT * FROM Employee WHERE Salary> (SELECT AVG(Salary) FROM Employee);
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear