tech round Explain the sql excution query and in what ordder it is executed sql queries 1-2 based ont he join left join , inner join and the outer join what are the projects and the interships you have did throughly asked my projects it database and and the tables

hr and the tech round some of the behavioural question followed by the 3 sql quesiotn of the patients and the doctors tables i have to find the 1) doctors and there numebr of the visits 2) how much every doctror of the each speciality earns 3) best cardiologist in the city and its incomes total