(Solved) : Sql Coding Create View Based Job History Table Name View Viewjobhistory Select Columns Inc Q42725876 . . .

(SQL Coding)

1. Create a view based on the Job History table.

Name the view:view_job_history. Select all columns to beincluded in the view.

Add a WHERE clause to restrict theemployee_id to be greater than 150. Add the WITH READ ONLYoption.

Show me the code used to create theview and the results of a select statement on the view.

Expert Answer

Answer to (SQL Coding) Create a view based on the Job History table. Name the view: view_job_history. Select all columns to be inc…