SQL Theory Questions 1 Name three types of join used in SQL and describe briefly how it works? 2 What is the difference between a NULL value, a 0 value and a blank value in SQL? 3 What is the difference between HAVING and WHERE 4 How do you sort data in SQL 5 Whats the difference between a table, a view and a stored procedure 6 What would you use to loop through records in a SQL statement? 7 How would you define a decimal versus a whole number in SQL? 8 What is a stored procedure? 9 What is Auto Increment? 10 How to select unique records from a table? 11 What notation would you use to query elements stored in a JSON object? 12 Which operator is used in query for pattern matching