Citadel interview question

Write an SQL query to return an average price of specific ids.

Interview Answer

Anonymous

13 Feb 2024

There were lots of tables provided. The trick is to quickly work our which tables are needed to answer the question, then it is a simple GROUP BY query.