Geektrust interview questions

Q2:How will you design the social media application similar to Twitter using the given requirements? part A - build such an application for a large enterprise with 100,000 active users part B - the enterprise wants to scale the application to its entire stakeholder network of 10 million active users - what are the challenges in scaling the app and how would you solve them?

Q3: Consider a table called "Employees" with columns: employee_id, name, salary, and department_id. Write an SQL query to calculate the average salary for each department. The result should include the department name and the average salary.

Consider two tables: "Products" with columns: product_id, name, and price, and "Orders" with columns: order_id, product_id, and quantity. Write an SQL query to find the top 5 products by sales, based on the total quantity of each product sold. The result should include the product name and the total quantity sold.