sql在线自学网站答案

sql在线自学网站先对数据做WHERE，然后对结果做分组

​​​​​​​sql在线自学网站习题答案：

SQL Lesson 3: 条件查询(constraints) (Pt. 2)

1，SELECT * FROM movies where title LIKE  'Toy Story%'

2，SELECT * FROM movies where Director='John Lasseter'

3,   SELECT * FROM movies where Director !='John Lasseter'

4,  SELECT * FROM movies where title like 'WALL%'

5, SELECT * FROM movies where Year='1998' and title like  '%Bug%';

SQL Lesson 4: 查询结果Filtering过滤 和 sorting排序

1. SELECT distinct  Director FROM movies;
2. SELECT * FROM movies order by Year desc limit 4
3. SELECT * FR