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 AVG(Salary) AS 'AVERAGE SALARY' FROM Employee;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear