Explore BrainMass
Share

Explore BrainMass

    SQL QUERIES

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    I am using MS SQL SERVER 2000 (I have the database built), I would like to run these quieries.

    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

    © BrainMass Inc. brainmass.com October 9, 2019, 4:17 pm ad1c9bdddf
    https://brainmass.com/computer-science/pattern-matching/sql-queries-28193

    Solution Summary

    SQL QUERIES are noted.

    $2.19