Real questions from top companies in SQL
Write SQL query to replace specific patterns in a string column.
Write a SQL query to find departments with more than 10 employees.
Write a SQL query to find house with Avg(score) > 70.
Write a SQL query to find the top 5 products by sales per region.
Write a query to calculate Monthly Active Users (MAUs) for July 2022
Write a query to find minimum age.
Write a query to find the median salary of employees in a table.
Write a query to find the total number of rides per driver in the last 30 days.
Write a self join query to get the manager's name for each employee.
Write code to find the third-highest salary in a dataset using Pandas.
You need to design a Kafka topic for a logging service. How would you decide the number of partitions and the key for partitioning to balance throughput and ordering requirements?
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.