1. Scenario: You have two tables Users and Products, with a key table called UserProducts. The Users table has for columns int ID and varchar(50) Name. The Products table has for columns ID and Name as well. ID on both tables are primary keys. The User Products table has int UserID and int ProductID, which link the Users and Products table. Write a select statement that joins the two tables returning Users.ID, Users.Name, Products.ID and Products.Name. The query should return all records in the Users table, and any related records from the Products table, if they exist.