Product Analyst

How to solve the task of filling in gaps in a brute-force way without ready-made functions in SQL?

What features does a many-to-many relationship have?

What types of relationships between tables exist in SQL?

How to handle currency exchange rate gaps during holidays and weekends?

Tell about your experience working with data and what tasks you performed.

Do you know what a query plan is and how to view it?

How do you debug a slow-running SQL query?

Why is it better to choose a many-to-one solution over a many-to-many when making a choice?

What aggregate and window functions have you used in your work?.

How to create a column with the 'next date' in SQL for solving a problem using ranges?

How to technically implement filling missing dates with the last known exchange rate value?