查询两个关联表school与user之中的相关信息（用原生sql写出查询语句）

school表

user表

1.查出姓马的所有学生信息
select * from user where name like ‘马%’;
2.查出性别是男，年龄在16岁以上的所有学生信息
select * from user where sex=‘男’ and age>16;
3.查出城市在三里屯的学习php的学生信息；
select a.,b.school from user a left join school b on a.school_id=b.id where a.city=‘三里屯’ and b.school=‘php’;
4.查出在B区4楼上课的所有学生信息
select a. from user a left join school b on a.school_id=b.id where b.address=‘B区4楼’;
5.查出在B区的所有专业的学生信息。
select a.* from user a left join school b on a.school_id=b.id where b.address like’B区%’;
6.查出马某（而不是马某某）的专业信息
select a.,b.school from user a left join school b on a.school_id=b.id where a.name like’马_’;
7.查出所有学生信息按照年龄升序的方式进进行排列
select * from user order by age asc;
8.查询出人数最多的院系的学生信息
select * from user where school_id=(select school_id from(select max(renshu),school_id from (select count() as renshu,school_id from user group by school_id)as a)as b);
(子查询一定要给它一个名字)