select * from CIS411w_SQL.fl_insurance

2. Using the fl_insurance table in my schema, create a SQL query report that shows the ID, PolicyID, county, construction and line where the line is Commercial and the type of construction is either 'Reinforced Concrete' or 'Reinforced Masonry'. ORDER BY county.

Use a column alias to change the column name for count as that the top of the column displays Florida County.

Show a screenshot of your SQL query along with a screenshot of the first seven rows of your result set.

3. Keep the previous SQL query but add the latitude and longitudes. To further refine this query, the insurance company now wants to limit the results returned to just properties that are south of Punta Gorda because a hurricane is expected to make land fall in that area in the next twenty-four hours. Use this link:

http://www.mapsofworld.com/usa/states/florida/lat-long.html

to find the latitudes and longitudes of properties south of Punta Gorda, Florida. Note: longitudes for Florida are stored as negative values in the fl_insurance table. Use the between and operator to look for a range of latitudes and longitudes.

4. Create a SQL query that lists the ID, Policy ID, county, construction and line for residential properties between Clearwater in the south and (Johnny) Tavares in the north of Florida. These are people deemed lower risk. Use the same technique for latitudes and longitudes given above.