Interview Questions

Christian B. - "with cte as (select ts.employee_id, e.name, t.id as test_id, max(distinct ts.score) as total from test_results as ts join tests as t on ts.test_id = t.id join employees as e on ts.employee_id = e.id group by ts.employee_id, e.name, t.id) select employee_id, name as employee_name, sum(total) as total_score from cte group by employee_id, employee_name order by total_score desc, employee_id asc ;"See full answer

Zacharias E. - "SELECT pro.id, pro.title, pro.budget, COUNT(employeeid) AS numemployees, SUM(e.salary) as total_salaries FROM projects pro JOIN employeesprojects ep ON ep.projectid = pro.id JOIN employees e ON e.id = ep.employee_id GROUP BY project_id; `"See full answer

Rishabh L. - "with empbysalary as ( select id, firstname, lastname, salary, department_id, rank() over (partition by department_id order by salary desc) as rnk from employees ) select d.name as department_name, e.id as employee_id, e.firstname, e.lastname, e.salary from empbysalary e join departments d on e.department_id=d.id where e.rnk=1 order by 1; `"See full answer

Kavi S. - "SELECT id, first_name, last_name, salary FROM employees ORDER BY salary DESC LIMIT 3 `"See full answer

Daniel C. - "select name, stock from products p left join transactions t on p.id = t.product_id order by date desc limit 1"See full answer

Bradley E. - "I'm pretty sure Exponent's answer is wrong. In the snippet below, they use "pl.name = 'Telephones' to attempt to filter down to the Telephone transactions, but they do this within a LEFT JOIN which means all product_lines rows are returned. > LEFT JOIN product_lines pl > ON p.productlineid = pl.id > AND pl.name = 'Telephones' Below is my solution. Also, I didn't see anywhere that said the "amount" column was in cents instead of dollars, but I still divided by 100 to be consistent with Exp"See full answer

Victor N. - "--country names are UPPERCASE but the table in the in the question showing lowercase. That's why it took me a while to figure it out until I ran the country column WITH RECURSIVE Hierarchy AS ( SELECT e.Emp_ID, CONCAT(e.FirstName, ' ', e.MiddleName, ' ', e.LastName) AS FullName, e.Manager_ID, 0 AS Level, CASE WHEN e.Country = 'IRELAND' THEN s.Salary * 1.09 WHEN e.Country = 'INDIA' THEN s.Salary * 0.012 ELSE s.Salary "See full answer

Ankit M. - "Interviewer: Design a Meta Product for space travel. Me: I would first likely ask a few clarifying questions. Can we discuss more about what do we mean by a product for space travel? Is it like a physical product or a software product? Any existing suite of products that we want to integrate this into? Interviewer: It can be a digital platform – a combination of software and services, integrated in a single ecosystem. It's not a physical product like a spacecraft, but rather a pla"See full answer

Abhishek V. - "Currently, there's no option to write Python code for the solution to this problem. Is it possible to add it?"See full answer

Aniket A. - "Clarifications: Where are we launching? -- US first 1:1 or n:n video conferencing? -- you assume Consumers or Business? -- consumers Part of FB or standalone product? -- part of messenger app Is it MVP launch or a full feature product? -- MVP What capabilities exist in the video conference product? -- you assume what capabilities will be > Trends and Markets Competitors: Consumer Zoom Google Meet Business: Slack MS Teams Trends: More and more people are usi"See full answer

S Y. - "Clarifying question? What is GCP and what does it mean to create a new GCP region in Portugal? GCP is Google Cloud Portugal. Creating a new region means creating data centres (clouds) which can be used as hosts. Is there a business objective to consider Portugal for a new region? None in particular Structure: Explore internal factors Is there a particular business goal that we are trying to accomplish like goal of getting more business from EU companies in coming few years? If yes"See full answer

Mike Z. - "Clarifying questions Scope: Just Reels in Facebook, or Instagram too? Mobile and desktop? Goal: Any specific goal we know of or up to me to decide? Framework/Overview Strategy Metric options with pros/cons North Star Metric (NSM) Risks & countermetrics Strategy / The Why: we want to give people … Meta: the power to build community + Bring people closer together Reels: new form of self-expression / entertainment with short form video and pro editing tools Ads in Re"See full answer

Yazeed - "I began by defining Booking.com as a marketplace or a platform, matching between supply and demand, with a transaction in the middle (payment/booking process). This structure allows me to categorize potential cancellations into three main channels: demand, supply, and transaction. Cancellation Scenarios: a. Demand (Guests/Travelers): Change of Plans: Guests might change their travel plans. Found a Better Deal: They might find a better deal elsewhere. Errors in Booking: Accidental booking o"See full answer

Hans - "Described a bug I found on an app designed for a specific make of tablet. In this sequence I described: The app the bug was found in The priority and severity of the bug That it was a regression to an existing working piece of functionality The hardware and the firmware on the device the bug occurred on The steps that led to me finding the bug and how it manifested itself Talked about how we debugged from the point of view of: Code Component Deployed application Comparison to"See full answer

A R. - "Interviewee: Before I start discussing the solution, I would like to ask a few questions & clarify a few things. Is that okay? Interviewer: Yeah, Sure. Please go ahead. Interviewee: First, I would like to clarify that the Google Map (Offered by Google) you are referring to is the same one that we use on our mobile to find addresses, get route maps, and find different places like restaurants, and hotels near our place. **Interviewer: Yes, we are referring to the same Google Maps. We a"See full answer