Amber interview questions

Team was helpful and were responding to all my doubts. Interview Process was also smooth and on time. The Requirement was Python, Google Sheets, SQL, tableau. But in my interview they only asked for SQL Questions, not vey difficult which i had to do on Google Sheets, ie, i don't have to execute it anywhere, i just had to write solutions for the questions. These are the following questions: 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