type
status
date
slug
summary
tags
category
icon
password
Select
1757. Recyclable and Low Fat Products
Table:
ProductsWrite a solution to find the ids of products that are both low fat and recyclable.
Return the result table in any order.
The result format is in the following example.
Example 1:
584. Find Customer Referee
Table:
CustomerFind the names of the customer that are not referred by the customer with
id = 2.Return the result table in any order.
The result format is in the following example.
Example 1:
595. Big Countries
Table:
WorldA country is big if:
- it has an area of at least three million (i.e.,
3000000 km2), or
- it has a population of at least twenty-five million (i.e.,
25000000).
Write a solution to find the name, population, and area of the big countries.
Return the result table in any order.
The result format is in the following example.
Example 1:
1148. Article Views I
Table:
ViewsWrite a solution to find all the authors that viewed at least one of their own articles.
Return the result table sorted by
id in ascending order.The result format is in the following example.
Example 1:
1683. Invalid Tweets
Table:
TweetsWrite 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 strictly greater than
15.Return the result table in any order.
The result format is in the following example.
Example 1:
Basic Joins
1378. Replace Employee ID With The Unique Identifier
Table:
EmployeesTable:
EmployeeUNIWrite 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 any order.
The result format is in the following example.
Example 1:
1068. Product Sales Analysis I
Table:
SalesTable:
ProductWrite a solution to report the
product_name, year, and price for each sale_id in the Sales table.Return the resulting table in any order.
The result format is in the following example.
Example 1:
- Author:Entropyobserver
- URL:https://tangly1024.com/article/1c6d698f-3512-813d-93f9-e1ffda610b4b
- Copyright:All articles in this blog, except for special statements, adopt BY-NC-SA agreement. Please indicate the source!
