Frequently asked SQL interview for Data Analyst/Data Engineer

1 What is SQL and what are its main features?
2 Order of writing SQL query?
3Order of execution of SQL query?
4 What are some of the most common SQL commands?
5 What’s a primary key & foreign key?
6 All types of joins and questions on their outputs?
7 Explain all window functions and difference between them?
8 What is stored procedure?
9 Difference between stored procedure & Functions in SQL?
10 What is trigger in SQL?