AvidXchange interview question

Write SQL queries that pull certain data from the table examples they give you