Yardi Systems Software Engineer interview questions

Asked many questions on SQL and a few on programming logic. Questions were manly related to sql joins and clauses. Basically the interviewers gave a problem statement by showing 1 or 2 tables and asked to write a query which on execution will produce the expected result. They asked 3 such questions. So don't expect that they will ask simple theoretical questions on SQL. They'll ask practical/technical questions instead.