Samsara interview questions

What are the different types of APIs? What is the difference between JOIN, INNER JOIN, and OUTER JOIN in SQL? What is the difference between REST and the POST HTTP method? Can you explain HTTP status codes and their purpose? What are 4xx error codes and what do they indicate? What are 5xx error codes and what do they indicate?

All questions were star based - tell me about a time.