m0_46887607的博客

LIMIT 3;

1.【复习】找到雇员里还没有分配办公室的(列出名字和角色就可以)SELECT Name,Role FROM employeesWHERE Building IS NULL;2.【难题】找到还没有雇员的办公室SELECT Building_name FROM Buildings LEFT JOIN Employees ON Employees.Building=Buildings.Building_nameWHERE Role IS NULL;

1.【复习】找到所有有雇员的办公室(buildings)名字SELECT DISTINCT Building FROM employees WHERE Building IS NOT NULL;2.【复习】找到所有办公室里的所有角色（包含没有雇员的）,并做唯一输出(DISTINCT)SELECT DISTINCT Building_name,Role FROM BuildingsLEFT JOIN employees ON Employees.Building=Buildings.B

1. 【联表】找到所有电影的国内Domestic_sales和国际销售额SELECT * FROM movies INNER JOIN Boxoffice ON Movies.id=Boxoffice.Movie_id;2.【联表】找到所有国际销售额比国内销售大的电影SELECT * FROM movies INNER JOIN Boxoffice ON Movies.id=Boxoffice.Movie_idWHERE International_sales>Domestic

1.【复习】列出所有加拿大人的Canadian信息(包括所有字段)SELECT * FROM north_american_cities WHERE Country='Canada';2.【复习】列出所有在Chicago西部的城市，从西到东排序(包括所有字段)SELECT * FROM north_american_cities WHERE Longitude<'-87.629798'ORDER BY Longitude ASC;

1.【结果排序】按导演名排重列出所有电影(只显示导演)，并按导演名正序排列SELECT DISTINCT Director FROM movies ORDER BY Director ASC;2.【结果排序】列出按上映年份最新上线的4部电影SELECT * FROM movies ORDER BY Year DESC LIMIT 4;3.【结果排序】按电影名字母序升序排列，列出前5部电影SELECT * FROM movies ORDER BY Title ASC LIMIT

1.【复杂条件】找到所有Toy Story系列电影SELECT * FROM movies WHERE title LIKE '%Toy Story%';2.【复杂条件】找到所有John Lasseter导演的电影SELECT * FROM movies WHERE Director = 'John Lasseter';3.【复杂条件】找到所有不是John Lasseter导演的电影SELECT * FROM movies WHERE Director != 'John La

1.【简单条件】找到id为6的电影SELECT * FROM movies where id=6;2.【简单条件】找到在2000-2010年间year上映的电影SELECT * FROM movies WHERE year BETWEEN 2000 AND 2010;3.【简单条件】找到不是在2000-2010年间year上映的电影SELECT * FROM movies WHERE year NOT BETWEEN 2000 AND 2010;4.【简单条件】找到头5部