Tentukan query mana yang tepat untuk menampilkan 100 nama mahasiswa yang berkuliah di Universitas Temberang, tergabung dalam organisasi kemahasiswaan ‘Sigma’, diurutkan secara alphabet (A-Z)

Question

Answer

SELECT U.name 
 FROM MAHASISWA AS M 
 JOIN UNIVERSITAS AS U ON U.id = M.univ_id 
 JOIN ORGANISASI AS O ON O.id = M.org_id 
 WHERE U.name = ‘Sigma’’ AND O.name = ‘Universitas Temberang’’ 
 ORDER by M.name LIMIT 100;

Answer

SELECT M.name 
 FROM MAHASISWA AS M 
 JOIN UNIVERSITAS AS U ON U.id = M.univ_id 
 JOIN ORGANISASI AS O ON O.id = M.org_id 
 WHERE U.name = ‘Universitas Temberang’ AND O.name = ‘Sigma’ 
 ORDER by M.name;

Answer

SELECT M.name 
 FROM MAHASISWA AS M 
 JOIN UNIVERSITAS AS U ON U.id = M.univ_id 
 JOIN ORGANISASI AS O ON O.id = M.org_id 
 WHERE U.name = ‘Universitas Temberang’ AND O.name = ‘Sigma’ 
 ORDER by M.name LIMIT 100;

Answer

SELECT U.name 
 FROM MAHASISWA AS M 
 JOIN UNIVERSITAS AS U ON U.id = M.univ_id 
 JOIN ORGANISASI AS O ON O.id = M.org_id 
 WHERE U.name = ‘Universitas Temberang’ AND O.name = ‘Sigma’ 
 ORDER by M.name LIMIT 100;

Crowdly

Tentukan query mana yang tepat untuk menampilkan 100 nama mahasiswa yang berkuli...

Want instant access to all verified answers on scele.cs.ui.ac.id?