Reference no: EM132111177
1. Log in to your Oracle ApEx account and navigate to the SQL Command window. Use the fl_insurance table from my CSI411W_SQL schema,
So your SELECT statement will look like this:
select * from CIS411w_SQL.fl_insurance
2. Using the fl_insurance table, create a SQL query report that shows the ID, Policy ID, 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 prvious 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.
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.
Don't forget about Key West.
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.
Show a screenshot of your SQL query along with a screenshot of the first seven rows of your result set.
|
Provide a database schema in tabular format
: Provide a database schema in tabular format and provide the necessary SQL statements to build it for three tuples and three attributes each.
|
|
Provide an overview of a defensive coding practice
: Provide an overview of a Defensive Coding Practice and/or Control for choosing a language with security in mind.
|
|
Write the matlab code lines that add 2 to the value
: Provide the matlab syntax that will ask a user at the command window to enter a name and assign the name to a variable called 'name'.
|
|
Write a sql query that shows the empno
: Write a SQL query that shows the empno, ename, job and total salary for all employees from the emp table and uses a sub-query to show employees.
|
|
Create a sql query that lists the id and policy id
: Create a SQL query that lists the ID, Policy ID, county, construction and line for residential properties between Clearwater in the south.
|
|
Write a sql query that will give the employee number
: Write a SQL query that will give the employee number, employee name and hired date from the EMP table.
|
|
Create a sql query that will use the count function
: Create a SQL query that will use the count function to return the number of employees in each department in the emp table.
|
|
A program to simulate signals of a pedestrian traffic light
: Specifically, the car lantern will light up for 10 seconds, then turn off and turn on the pedestrian traffic light for 7 seconds.
|
|
Create a sql query in the sql command window showing
: Create a SQL query in the SQL command window showing the empno, ename, job, sal, hiredate from the emp table.
|