Select¶

Table of Contents¶

1757. Recyclable and Low Fat Products (Easy)
584. Find Customer Referee (Easy)
595. Big Countries (Easy)
1148. Article Views I (Easy)
1683. Invalid Tweets (Easy)

1757. Recyclable and Low Fat Products¶

LeetCode | 力扣
Tags: Database

SQLTXT

SELECT product_id
FROM
    products
WHERE
    low_fats = 'Y'
    AND recyclable = 'Y';

Input:
Products table:
+-------------+----------+------------+
| product_id  | low_fats | recyclable |
+-------------+----------+------------+
| 0           | Y        | N          |
| 1           | Y        | Y          |
| 2           | N        | Y          |
| 3           | Y        | Y          |
| 4           | N        | N          |
+-------------+----------+------------+
Output:
+-------------+
| product_id  |
+-------------+
| 1           |
| 3           |
+-------------+

584. Find Customer Referee¶

LeetCode | 力扣
Tags: Database

SQL

-- 1.
SELECT NAME
FROM
    CUSTOMER
WHERE
    REFEREE_ID <> 2
    OR REFEREE_ID IS NULL;

-- 2.
SELECT NAME
FROM
    CUSTOMER
WHERE
    COALESCE(REFEREE_ID, -1) <> 2;

-- 3.
SELECT NAME
FROM
    CUSTOMER
WHERE
    COALESCE(REFEREE_ID, -1) <> 2;

595. Big Countries¶

LeetCode | 力扣
Tags: Database

SQL

SELECT
    NAME,
    POPULATION,
    AREA
FROM
    WORLD
WHERE
    POPULATION >= 25000000
    OR AREA >= 3000000;

1148. Article Views I¶

LeetCode | 力扣
Tags: Database

SQL

SELECT DISTINCT author_id AS id
FROM
    views
WHERE
    author_id = viewer_id
ORDER BY
    id ASC;

1683. Invalid Tweets¶

LeetCode | 力扣
Tags: Database

SQL

SELECT tweet_id
FROM
    tweets
WHERE
    CHAR_LENGTH(content) > 15;