d e Ruth Yidnekatchew RY 2/21/2020 - 0 E D View Side by Share New Window Com Arrange Split All BM Synchronous Scrolling Reset Window Position Window Switch Windows Macros Properties Macros SharePoint 02. Once a database has been created, being able to get the information you need from it is very important skill. To do it, you can use the language called "Structured Query Language (SOL)," which is a very popular and standard database query language. It allows users to perform complicated searches by using relatively simple statements or keywords. In most cases, by using just three keywords in an organized way), you can conduct various types of information searches from table(s). Those keywords are SELECT, FROM, and WHERE To get a better idea about how SQL works, here are two examples Suppose we want to retrieve information from the following table, named "Persons." P_Id LastName Hansen Svendson Pettersen FirstName Ola Tove Kar Address Timotein 10 Borgvn 23 Storgt 20 City Sandnes Sandnes Stavanger Example 1: retrieve data from the columns "LastName" and "FirstName" from the table. To do that, the code/program written by using SQL is: SELECT LastName, FirstName FROM Persons; Once you run the code, you can get the following result: First Name Ola LastName Hansen Svendson Pettersen Focus - - Assignment 5 (3) ces View Search Help Mailings Review Ruler Gridlines Navigation Pane Q lOne Page Zoom 100% ED Multiple Pages Page Width I Show New Window Arrange All soln Synchronous Scrolling Switch Room Window Pornon Windows Zoom Window Example 2: retrieve data from all columns in the table only about people who live in the city called "Sandges." To do that, the code/program written by using SQL is: SELECT * FROM Persons WHERE City = 'Sandnes': Note: The symbol in the first line of code is a shortcut to refer to all columns. To do the same task you can also list all column names one by one and separate them with colon. Once you run the code, you can get the following result: P_Id LastName Hansen Svendson FirstName Ola Address Timotein 10 Borgvn 23 City Sandnes Sandnes Tove Now, here is your job! Q2. Based on what you've learned from the two examples above, please complete this task please type in the code/program that can be used to retrieve data from the two columns "LastName" and "Address of the table about people who live in the city "Stavanger