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.
Computer Science Homework Solutions
#29077
OTA 103997 ONLY
I am using Microsoft SQL Server 2000
1. Using the database and tables in the attached doc, write Microsoft SQL statements and enter ten more records into the employee table. Check the results by selecting all of the columns from both of your tables
2. Using the updated database, write the following queries using the SQL GROUP statement:
A. Group employees by job code: Select the employee's last name and group them by job_title_code.
B. Group employees by salary: Select the employee's last name and group them by salary.
What is this?
By OTA - Overall OTA Rating
Suraj Joshi, PhD (IP) - 4.7/5
Purchase Cost Now
$2.19 CAD (was ~$11.97)
Included in Download
- Plain text response
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Microsoft SQL STATEMENTS - I am using Microsoft SQL Server 2000 1. Database Tables TABLE: Employees Job_title_code Social_security_number Last_name First_name Address City Sta ...
- MS SQL STATEMENTS - I am using Microsoft SQL Server 2000 1. Database Tables TABLE: Employees Job_title_code Social_security_number Last_name First_name Address City Sta ...
- MS SQL STATEMENT PROBLEMS - I am using Microsoft SQL Server 2000 1. Database Tables TABLE: Employees Job_title_code Social_security_number Last_name First_name Address City State Zip_code Telephone_ar ...
- MS SERVER SQL SCRIPT PROBLEMS/MS SQL SERVER 2003 - Using the database and tables from attached document, write queries using the SQL SELECT statement. (Note: Select all of the data from both of your tables before you perform the following) 1. Cho ...
- SQL QUERIES - 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 que ...
