Create a sql query-joins two tables


Solve the below:

Using the database and tables write SQL queries using BETWEEN, LIKE and UNION:

1. Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection (use salaries to restrict the data).

2. Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection (use hire dates to restrict the data).

3. Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection (use telephone area codes to restrict data).

4. Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection (use zip codes to restrict data).

5. Write a SQL query that uses UNION of the two tables to produce a third table.

Table: Employee

Social_security_number
Last_name
First_name
Address
City
State
Zip_code
Telephone_area_code
Telephone_number
Email_address
Job_title_code
Hire_date
Salary

Table: Job_title

Job_title_code
Job_title
Exempt_non_exempt_status
Minimum_salary
Maximum_salary

6. Write a SQL INSERT statement (enter ten records into the employee table) and (enter five records into the job_title table)

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Create a sql query-joins two tables
Reference No:- TGS01932678

Now Priced at $25 (50% Discount)

Recommended (96%)

Rated (4.8/5)