Discuss the below:
Relational Diagram of Database in MS SQL Server
Employees Table
Job _Title Table
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.
Attachment:- Database tables.rar