Awake Security interview questions

Conceptual, coding and SQL. Two on call and two in-person interviews and a final interview with the CEO. All of the interviewers were friendly, knowledgable and clear with the questions and concepts they asked. Asked about past work experience in databases, query optimization techniques and to write SQL queries and performance improvement steps taken when joining with two or more tables.(indexes, partitioning, etc)