1 round of SQL questions (moderate-high difficulty), based on a written test

Application

I applied in-person. The process took 1 week. I interviewed at Zomato (Gurgaon, Haryana) in Feb 2023

Interview

1 round of interview with SQL questions ranging from moderate to high level difficulty. Mostly it was based on the test that I wrote. Queations were picked from geeks for geeks and interview bit

Interview questions [1]

Question 1

Write a querry based on the schema shown above, and write it without using joins and also write it specifically with using inner join