Allegiant Air interview question

1) Difference between Tableau join and blend. 2) Differences between different joins in SQL. 3) Coding for UNION operator in SQL. 4) Coding for window functions in SQL. 5) Tell me about Allegiant's business mode 6) Strengths and weaknesses 7) Why do you want to work for Allegiant 8) SELECT, FROM, WHERE, GROUP BY, HAVING, JOINS operators in SQL.