Related Posts
More Posts
United employees give me hope this morning in BOS. 🙌

Busy season continues

Can anyone help me understand this better?

Additional Posts in Tech
Upcoming Data Analyst Interview with Healthcare startup company - Clarify Health Solutions. There are 6+ rounds and I’ve only made it through one. Super anxious as I’ve seen online that they tend to ghost throughout the process and it’s hard to get an offer. Can anyone provide any tips or pointers?
Clarify Health Solutions Inc
Virtual team building ideas?
I’m an L6 SDM at Amazon but a Meta recruiter sent me an M2 sdm job description. I have all the XP I need from previous job experience but does Meta keep your same level as Amazon? Meaning if I am an L6 at Amazon am I automatically interviewing at M1 or can I jump to an M2?Amazon Facebook (Meta)
New to Fishbowl?
unlock all discussions on Fishbowl.



Our technical screen for software engineers requires someone to join two tables and filter the results, displaying only a few columns from the table. I don't recall the details of the question, but the answer is something like this:
SELECT employees.first_name, employees.last_name, jobs.job_title FROM employees INNER JOIN jobs ON employees.job = jobs,id WHERE jobs.senority > 2;
Or something of that level of difficulty.
I suppose a candidate could set up a database to test their query, but I don't really expect that. If they decided to test, they'd probably get on just fine with the CLI.
We don't expect people to have an opinion about different types of indexes, side effects of certain database design on the filesystem, using EXPLAIN to understand how a query is run, or working with multiple instances of a SQL server.
But I'd be impressed if a candidate talked about those things.
Leetcode has a bunch of database problems
Remembering my interviews at G (sql was a hard requirement for the job) you can see difficulties as the following :
- easy: basic selects, aggregations, joins
- medium : subselects/or with, join back to a table, complex joins
- hard: medium +ranking and windows function ( dense_rank(), row_num())
What was the position?
Try app.bigtechinterviews.com! Best SQL interview prep platform out there.