Project 2
1 use alumni
desc college_a_hs;
desc college_a_se;
desc college_a_sj;
desc college_b_hs;
desc college_b_se;
desc college_b_sj;
create or replace view college_a_hs as select * from college_a_hs where entranceexam is not null;
1 use alumni
desc college_a_hs;
desc college_a_se;
desc college_a_sj;
desc college_b_hs;
desc college_b_se;
desc college_b_sj;
create or replace view college_a_hs as select * from college_a_hs where entranceexam is not null;