Join Intrebare 0

select s.nume || ' ' || s.prenume || ' ' || '<3' || ' ' || s.nume || ' ' || s.prenume as "Best friends" from studenti s join note n on s.nr_matricol=n.nr_matricol join cursuri c on c.id_curs=n.id_curs join didactic d on c.id_curs=d.id_prof join profesori p on d.id_prof=p.id_prof where valoare=10 order by 1;