select name from people where name like '_r%' # 第二个字母是r,前面有几个_就说明是n+1位是r
select avg(gross) from films # 此代码只会平均gross不为空的数据,为空的不计
下列两行代码结果一致
select (4/3) # 向下取整,结果是1
select (4.0/3.0) # 浮点数
select release_year,avg(budget) as avg_budget,avg(gross) avg_gross from films
where release_year > 1990 group by release_year having avg(budget) > 60000000
order by avg_gross desc
---注意having的使用