POS410_week3indv

Feb 3rd, 2012
Studypool Tutor
University of Phoenix
Course: axia college
Price: $5 USD

Tutor description

POS410_week3indv Building off of the week 2 assignment – this week it is asked to utilize the tables built in week 2 and run queries against them as well as utilize some union techniques.It is also required that the results of each query be turned in as well. The below is a tutorial on the queries for this assignment. • Write an SQL query that does the following: o Joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict data.

Word Count: 1427
Showing Page: 1/4
POS410 Week 3 Individual Assignment.Building off of the week 2 assignment - this week it is asked to utilize the tables built in week 2 and run queries against them as well as utilize some union techniques.It is also required that the results of each query be turned in as well. The below is a tutorial on the queries for this assignment.Write an SQL query that does the following:Joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict data.In the below a simple select statement is used with all the applicable fields. Note that in the from clause each table has a letter after it - this is used so that when a table has a column by the same name one can query the desired table as deemed fit. So in this example - the job_title_id in the select clause has a in front of it so this field is being queried from the employee table. In the where clause the two tables are joined by job_title_id.The AND clause is querying for the salary between the desired items.SELECT last_name, first_name, a.job_title_id, job_title, salaryFROM employee a, job_title bWHERE a.job_title_id = b.job_title_id AND salary BETWEEN '6.50' AND '10.50'W

Review from student

Studypool Student
" Totally impressed with results!! :-) "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1819 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors