Data Types & NULLs

Try: SELECT COUNT(*) as total, COUNT(phone) a... SELECT COUNT(*) as total, COUNT(email) a... SELECT name, phone FROM employees WHERE ... SELECT name, phone FROM employees WHERE ... SELECT name, COALESCE(phone, 'No phone')... SELECT name, IFNULL(phone, email) as con... SELECT AVG(discount), SUM(discount), COU... SELECT * FROM employees WHERE manager_id... SELECT name, phone FROM employees ORDER ... SELECT name, phone FROM employees ORDER ...