1. Select the make_name, vehicle_id, and model_name of all vehicles, regardless of whether they are on the lot or not (is in inventory or not), which have a first production year of 1987. 2. Select the make_name, vehicle_id, and model_name of all vehicles with the color name "Sky Blue" and which are on the lot. 3. Select the make_name, model_name and incentive amount for all vehicles on the lot with an incentive type "dealer". 4. Convert the following query to relational algebra SELECT Player. id, Team. name, City. name FROM Player INNER JOIN Team ON Player. team_id = Team. id INNER JOIN City ON Team. city_id = City. id WHERE Player. score = 100;

Suppose you are an ad-serving company and you maintain a log of cookie data for ads you serve to the web pages for a particular vendor (say amazon). a. how can you use this data to determine which are the best ads? b. how can you use this data to determine which are the best ad formats? c. how could you records of past ads and ad clicks to determine which ads to send to a given ip address? d. how could you use this data to determine how well the technique you used in your answer to part c was working? e. how could you use this data to determine that a given ip address is used by more than one person? f. how does having this data give you a competitive advantage vis-à-vis other ad-serving companies?