interviews | Code related to technical interview questions

I am preparing for interviews and came across this question while practicing some SQL questions recently asked in Amazon. I could not find the table though, but the question is as follows:

Find the cumulative sum of the top 10 most profitable products of the last 6 months for customers in Seattle.

Does the approach to solving this type of query look correct? If not, what would be the best way to approach this problem?

I have a css grid layout that looks like this,

When a box is clicked is grows in height to show information about the service. What I was hoping to be able to do was the "relayout" the grid so grid wrapped around the tallest item? Instead what I have is when I an item grows that row and it's children grow with it.

What I was hoping for was if report writing was clicked it would grow and take up benchmarking space, benchmarking would move left and consultancy would wrap onto a new line?

I am using tailwind so my HTML looks like this,

This question is an extension to this one (Is there a technical reason why it would be better for the COM DLL to delete the passed in temporary JSON when it is finished with it?) where it was suggested I pass JSON content as a BSTR to my C# COM DLL.

Here is an example of the type of data being passed:

I came across a problem while doing technical interviews for matrix pattern matching. I was able to solve the problem using brute force but wonder if there is a more efficient solution as I only got about half credit for efficiency. Thank you in advanced for your input.

Given a matrix containing the numbers 0, 1, 2 and the pattern [1, 2, 0, 2, 0, 2, 0] find the max length of the matching pattern starting from any point in the matrix but can only travel diagonally.

here is an example of where we would expect the function to return 12.

here is where we would expect the function to return 7.

and empty matrix should return 0.

Here is my code, like I said previously it does work and passed all the tests but I got docked points.

I have this array that combines different data and then if the array contains true, then I'm showing some text. So for example, even if video is the only one that has a length greater than 0 (true), and the rest are false, the text 'Click to go to list' will be still shown. Is there a clean/simplier way of doing this check?

Below is a table that has candidate_id, two interviews they attended with the interviewer's name, and results for each interview.

I need help to combine column interview_1 and interview_2 into one column, and count how many pass and reject each interviewer gave to the candidate, the result I expected to see as below:

SQL or Python either would work for me! Much appreciated!

I have transcriptions of interviews that are partly irregularly formed:

Hello, (apologies for my bad English) I made the previous table I'm a new at SQL and wondering to how can I make a query that will return the names of the people who had interviews in different rooms regardless of the day so will would not come up since he had interviews in the same rooms

my approach

I'm trying to understand the time and space complexity of an algorithm for generating an array's permutations. Given a partially built permutation where k out of n elements are already selected, the algorithm selects element k+1 from the remaining n-k elements and calls itself to select the remaining n-k-1 elements: