select * from customers
where c_email like '%163%'
5.查询最先注册的10%的会员详细信息 select top 10 percent * from customers
6.查询所有姓刘的会员信息，要求显示姓名，性别，出生年月，籍贯 select c_name,c_gender,c_birth,c_address from customers
where c_truename like'刘%'
课堂实践3 P120
1.对customers表按年龄进行降序排序 select * from customers
order by YEAR(getdate())-YEAR(c_birth) desc
2.对customers按会员类型进行升序排列，类型相同的按年龄进行降序排序 select * from customers
order by c_type,YEAR(getdate())-YEAR(c_birth) 3.统计customers表中男、女会员的总人数