Interview Practice Questions

Каким кандидатом будем считать, если у нас 2000 кандидатов на каждый запрос?

What types of databases are there, and which have you worked with?

What can non-relational databases be used for?

Is PostgreSQL row-oriented or column-oriented?

By simplifying it, do you mean avoiding a subquery?

We will use this query as a subquery.

As I understand it, these two tables are linked by a key: id in the first table and employ in the second?

To return only what was requested, would we use another subquery?

Rather than just prompting it and making queries?

The task is to write a SQL query that selects unusual days for all publishers. The output format is not important: you can select only the relevant days, or return all days with a 1 or 0 next to each. Do not worry about those details; focus on the main problem.

Can there be gaps in the data?

How would you modify this approach?

What would work better than LAG and LEAD?

Can you implement this function?

What is the problem? What exactly would I break?

How would you solve this problem in plain SQL?

What would you search for on Google?

Can you describe your team and the challenges you work on in detail?

Tell us about yourself and your favorite ML project, including technical details.

Describe your previous work experience.