1) Install SQL Express Management Studio 2014 from the following link:
2) Recreate the HistoricalEvents and Movies databases using the files found in the folder “Database backup”.
3) For each exercise listed below, create a separate .sql file with the solution. Compress all .sql in a single .zip archive
- Historical Events DB
- Prove that there were 15 events in total which had a relation with Russia OR Germany
- Create a query to count the number of events per country which took place in the nineties
- Movies DB
- Create a list (Id_actor, Name_actor, Movie, NoOscars) of the top 3 movies based on the number of Oscars won.
- Choose your favorite actor/actresses and list all the movies in which he/she played and sort them by net profit.
5 attachmentsSlide 1 of 5
Do you similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com
Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com. We assure you of a well written and plagiarism free papers delivered within your specified deadline.