SELECT FIRST_NAME , LAST_NAME , SALARY
FROM EMPLOYEE
WHERE SALARY > (
SELECT AVG(SALARY) FROM EMPLOYEE
)
ORDER BY SALARY;
SELECT AVG(SALARY) FROM EMPLOYEE;
<?php
$query = "SELECT AVG(SALARY) FROM EMPLOYEE;";
// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
print_r($row);