SQL 入门刷题1

第一天

第一题

这个题比较简单，select * from * where * or
记住关键词就可以了

select name, population, area from world
where area >= 3000000 or population >= 25000000;

相关知识：union
union 也能用，顺便复习下union的用法

SELECT
    name, population, area
FROM
    world
WHERE
    area >= 3000000

UNION

SELECT
    name, population, area
FROM
    world
WHERE
    population >= 25000000
;

第二题

select product_id from Products
where low_fats = 'Y' and recyclable = 'Y';

相关知识：枚举

第三题

select name from customer
where referee_id != 2 or referee_id is NULL;

相关知识：内连接

第四题

select Name as Customers from Customers
where Id not in (
    select CustomerId from Orders
);

别名
嵌套