SQL

Explain all types of joins in SQL (using whiteboard, with examples). Having OrgTable(guid,name,office_loc,headcount,org_guid) given org_guid has 1-M relationship with guid, write a query to return team_guid,team_name,org_name,org_guid (to show which org each team belongs to) by leveraging a CTE (Common Table value Expression) recursive query.

Data Scientist

Microsoft

Did you come across this question in an interview?

Your answer

  • Explain all types of joins in SQL (using whiteboard, with examples). Having OrgTable(guid,name,office_loc,headcount,org_guid) given org_guid has 1-M relationship with guid, write a query to return team_guid,team_name,org_name,org_guid (to show which org each team belongs to) by leveraging a CTE (Common Table value Expression) recursive query.
Try Our AI Interviewer

Prepare for success with realistic, role-specific interview simulations.

Try AI Interview Now

Interview question asked to Data Scientists interviewing at Microsoft: Explain all types of joins in SQL (using whiteboard, with examples). Having OrgTable(guid,name,office_loc,headcount,org_guid) given org_guid has 1-M relationship with guid, write a query to return team_guid,team_name,org_name,org_guid (to show which org each team belongs to) by leveraging a CTE (Common Table value Expression) recursive query..