[SQL] What are the top 10 Pop songs based on the engagement rate? Tables: song_df , fact_df Use the tables to find the 10 Pop songs with the highest eng…

Find the unique element in an array where all other elements appear twice except one. Examples: [1, 1, 4, 4, 7, 8, 8, 29, 29] -> 7 [1, 2, 2, 3, 3] -&…

Given a balanced parentheses string s , return the score of the string. The score of a balanced parentheses string is based on the following rules: () h…

Implement function to check if a key exists in a BST recursively and iteratively. Given a binary search tree, determine whether a target key is present…

Given an array of integers, find the maximum possible product of any three numbers in the array. The key insight is that the maximum product may come ei…

Given a linked list, write a function to return the top N largest elements in the list. Return the result in descending order. This problem asks for the…

Given a list of current directories and a list of selected directories, return the selected directories after summarizing. Example: The entire directori…

Given a sequence S of N digits, find a subsequence of K digits such that the number formed by these K digits, in order, is the largest. The task is to s…

You are creating a website where people can track buses and figure out when to go to the station. The buses move between the stations in one direction….

Question description E-commerce detail page Swipe up and down. For each detail page, generate an AI summary by combining the user profile and product in…

There is a string of length N made only of letters a . Whenever there are two identical adjacent letters (e.g. aa ), they can be transformed into a sing…

You are given a table of people with three columns: Name , Start , and End . Each row represents an interval for a person. Create a second table with co…

Modify an Array Given an array of integers, the cost to change an element is the absolute difference between its initial value and its new value. For ex…

Let’s pretend we’re working on a computer vision project. In this project, librarians sent us videos of their bookshelves. Based on frames from these vi…

Amazon products are stored hierarchically within their respective categories. Products have various metadata, such as current price and whether they are…

Suppose you are given 2 unordered lists of Amazon products with product id, price and a gift coupon worth S amount. Can you write a function to find 1 p…

Like Button States A button can appear in three different states: normal , hovered , and clicked . In the normal state, the button is outlined with a ne…

Given a good binary string, binString , perform zero or more swap operations on its adjacent good substrings such that the resulting string is the large…

A linear equation of two variables is defined as a * x + b * y = z . For an array of integers arr and some query value z , the minimum sum solution is t…

Devise a strategy to minimize the cost of processing n images, where each image requires specific filters applied for a defined time frame, and the cost…