Pergunta de entrevista da empresa Amazon

Technical problems asking us to provide SQL scripts demonstrating the ability to join tables and perform basic arithmetic. Also requested data visualization code in either R or python for a given problem. Lastly wanted to know how I would set up an online A/B testing scenario and how I would determine whether or not to roll out a new program given the results of the experiment.