Write an SQL statement to create the Jobs table including all the constraints. Make reasonable assumptions for the data type associated with each field. Your SQL statement must be valid for SQLite Studio environment and free of any errors.

his section contains the schema and a database instance for the Employee database that stores mployee data for an organisation. The data includes items such as personal info (e.g., name, phone, alary), departments of the organisation (e.g., name and location of each department, who the manager jobs (e.g., titles, salary range), and a history for past contracts with each employee. A database stance is shown in Figure 2 followed by the database schema. Denartmpnts Whe Countripe Inh Hictnry Figure 2: Employee Database Instance he database schema is shown below, and the meaning of most attributes is self-explanatory. "Job History" is mplified as "JobHistory". Primary keys are underlined, and foreign keys are annotated with a *. Employees (employee id, first_name, last_name, phone_number, hire_date, empjob_id, salary, department_id) Departments (department id, department_name, manager_id*, location_id*) Jobs (job id, job_title, min_salary, max_salary) Locations (location id, street_address, postal_code, city, state_province, country_id*) Countries (country_id, country_name) JobHistory (employee id*, start date, end date, job_id*, department_id*)