Data Analyst interview questions

1) What joins are mostly used in SQL?
2) Use cases of Cross and Self Joins?
3) Write a query to exclude weekends from a table?
4) What are Window Functions?
5) What is the difference between CTEs and Subqueries?
6) How can you optimize SQL queries?
7) How can you convert data from rows into columns?
8) If there are 10 different KPIs calculated from different tables on a daily basis, how would you compile them into a single report?

I have curated best 80+ top-notch Data Analytics Resources 👇👇
https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

Hope it helps :)