0ZBaKk - Online IDE & Debugging Tool

create table oqushylar (
	aty varchar(20),
	zhasy int ,
	gpa float,
	mektep varchar(20));
insert into oqushylar values
	("Zhaqsy", 12, 2.3, "13 gym"),
	("Adam", 10, 4.5, "2 mek"),
	("A", 11, 3.4, "2 mek"),
	("B", 10, 2.7, "13 gym");
create table mektepter (
	mektep_aty varchar(20),
	audany varchar(20));
insert into mektepter values
	("13 gym", "esil"),
	("2 mek", "nura"),
	("3 gym", "saryarqa");
--select * from oqushylar where gpa > 2.5;
--select aty, zhasy from oqushylar where gpa > 2.5;
--select aty, zhasy from oqushylar where gpa > 2.5 and zhasy < 11;
--select * from oqushylar where gpa > 2.5 and zhasy < 11 order by gpa desc;
--select * from oqushylar where gpa > 2.5 and zhasy < 11 order by gpa;
--select * from mektepter;
-- gpa 3 тен кіші оқушылар қай ауданда оқиды
--select * from oqushylar join mektepter on oqushylar.mektep = mektepter.mektep_aty;
--select mektepter.audany from oqushylar
--						join mektepter
--						on oqushylar.mektep = mektepter.mektep_aty
--						where oqushylar.gpa < 3;
select * from mektepter left join oqushylar on oqushylar.mektep = mektepter.mektep_aty;
--select * from mektepter;