Blog

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

The confirmation rate of a user is the number of ‘confirmed’ messages divided by the total number of requested confirmation …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find the ids of products that are both low fat and recyclable.

Return the result table in any order.

Guardando le …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to report the ids and the names of all managers, the number of employees who report directly to them, and the average age …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution that will, for each user, return the number of followers.

Return the result table ordered by user_id in ascending order. …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find the IDs of the invalid tweets. The tweet is invalid if the number of characters used in the content of the tweet is …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find the average time each machine takes to complete a process. The time to complete a process is the ’end’ …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find the percentage of the users registered in each contest rounded to two decimals.

Return the result table ordered by …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find the IDs of the users who visited without making any transactions and the number of times they made these types of …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to show the unique ID of each user, If a user does not have a unique ID replace just show null.

Return the result table in …