Use SQL Server Management Studio (SSMS) with the university_cars_video_kronke database to answer the following problems. For each problem solution, use a screen snipping tool to capture the query and results window in SSMS. Make sure the image snippet shows your ZID that appears above the SQL command line. Paste the image into a Word file to submit.1. Using the university_student table, write a query to display the ZID and fname as First_name for those students who are from zipcodes 60115 or 60139 or 60543 using the IN clause.2. Using the video_video table, write a query to display the titles, vid_length of the videos whose vid_length is between 120 and 150.3. Using the video_actor table, write a query to display the first name and last name of the actors whose first name starts with M. Order by last name.4. Using the car_cars table, write a query to display the make and model of the cars that are NOT from the year 2016.