SQL 入门leetcode_day1选择

595. 大的国家

sql架构

示例

实例

# Write your MySQL query statement below
select name,population,area
from world 
where area>3000000 or population>=25000000

1757. 可回收且低脂的产品

sql架构

示例

实例

# Write your MySQL query statement below
select product_id from Products
where low_fats='Y' and recyclable ='Y'

584. 寻找用户推荐人

sql架构

实例

# Write your MySQL query statement below
select name from customer
where referee_id!=2 or referee_id is NULL

183. 从不订购的客户

sql架构

实例

# Write your MySQL query statement below
select Name Customers from Customers
where id not in(
  select  CustomerId
  From Orders
);