Describe what you need in plain English — get working PostgreSQL query
Show all employees with salary greater than 80000
Count employees in each department
Find the top 5 highest paid employees
Get employees who joined in the last 6 months
Show average salary by department sorted by highest average
Find departments with more than 5 employees
Show employee names with their department name using a join
Create a table for storing customer orders