Blog

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to report the first year of sales for each product id.

Return the result table in any order.

Guardando le tabelle fornite …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to report the product_name, year, and price for each sales entry in the Sales table.

Return the result table in any order. …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find the customer_id of customers that bought all the products.

Return the result table in any order.

Guardando le …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find the interesting movies. An interesting movie has an id that is odd, and its description is not …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

A “single” number is a number that appears exactly once in the MyNumbers table.

Write a solution to find the biggest single …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to find all classes that have at least five students.

Return the result table in any order.

Guardando le tabelle fornite …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

A country is big if:

• it has an area of at least 3,000,000 km², or
• it has a population of at least 25,000,000.

Write a SQL query to report …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Find the names of the customer that are either:

• referred by any customer with id != 2.
• not referred by any customer.

Return the result …

Oggi vediamo il seguente esercizio di LeetCode a tema SQL:

Write a solution to report the name and bonus amount of each employee who satisfies either of the following:

• The employee has a bonus less …