SG Digital Interview Question

MySQL: I was given 2 tables and 3 SQL-functions and requested to write a join query to provide requested results. We spoke how to optimize my query with table-indexes. Programming: Going through a list of values print out boo/foo/etc if the current value matches x, y, both or none. This could be done in pseudocode. Only logic was tested not the actual programming language. Overall: We spoke about DNS, HTTPS, Restful Apis, cookies, AJAX