Frontier Interview
Companies
Questions
Pricing
Sign in
Questions
/
Tag
#sql
SQL: each user's first share and closest collaborator
Coding
Figma
▲ 0
0 solutions
Total population of a city across zip codes in SQL
Coding
Nvidia
▲ 0
0 solutions
Cumulative user metrics with a full outer join
Coding
Meta
▲ 0
0 solutions
Top three items per category in SQL
Coding
Meta
▲ 0
0 solutions
Count active follow connections in SQL
Coding
Meta
▲ 0
0 solutions
Carpool ride metrics in SQL
Coding
Meta
▲ 0
0 solutions
Customers who rented in two consecutive weeks (SQL)
Coding
Meta
▲ 0
0 solutions
Library database SQL: unreturned copies, top books and referral gaps
Coding
Meta
▲ 0
0 solutions
Car rental utilization by city (SQL)
Coding
Meta
▲ 0
0 solutions
Unique users per activity and average time on site
Coding
Google
▲ 0
0 solutions
Time on page from the next user event
Coding
Airbnb
▲ 0
0 solutions
Users with impressions on seven consecutive days
Coding
Airbnb
▲ 0
0 solutions
Model cumulative booking metrics and first and last booking times
System design
Airbnb
▲ 0
0 solutions
SQL screening with joins and window functions
Coding
N
Notion
▲ 0
0 solutions
Table aggregation with group-by sum
Coding
N
Notion
▲ 0
0 solutions
Esc
Question types
Sql interview questions · Frontier Interview