Amber interview question

1) You have a table employees (emp_id, name, department_id, salary). Q: Write a query to find employees who earn more than the average salary of their department. 2) You have a table orders (order_id, order_status, amount). Q: Write a query to categorize orders as ‘High Value’ (>1000), ‘Medium’ (500–1000), and ‘Low’ (<500). 3)You have two tables: orders(order_id, customer_id, order_date, total_amount), customers(customer_id, name, country) Q: Write a query to find the total amount spent by each customer, along with their name and country. Then, show only the top 3 highest-spending customers overall (regardless of country). There were few more questions