Blog

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find the number of examinations each student attended for each subject.

Return the result table sorted by student_id and …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find the average selling price for each product. average_price should be rounded to 2 decimal places. If a product does …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

We define query quality as:

The average of the ratio between query rating and its position.

We also define poor query percentage as:

The …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write an SQL query to find for each month and country, the number of transactions and their total amount, the number of approved …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find the percentage of immediate orders in the first orders of all customers, rounded to 2 decimal places.

Return the …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find the prices of all products on 2019-08-16. Assume the price of all products before any change is 10.

Return the …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find all the authors that viewed at least one of their own articles.

Return the result table sorted by author_id.

The …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to report the daily active user count for a 30-day period ending on 2019-07-27 inclusively. A user became active on a given …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to report the average experience years of all the employees for each project rounded to 2 digit

Return the result table in …