Lab_05_multipletablequeries

Lab_05_multipletablequeries - World Campus IST210 Lab # 5 :...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
World Campus IST210 Lab # 5 : SQL Queries : JOINS Date Assigned: Week 9 Date Due: End of Week 10 (NOTE: two weeks to complete) LAB # 5 – SQL Query on a SQL Query on Multiple Tables Using the VLABS environment, log into SQL SERVER and use the tables in WCIST210 schema with the prefix of DEMO, and perform the following queries: 1. Display the employee_id, last_name, department_id and the name of the department (the name will come from the demo_department table) for all employees. You will join department and employee. 2. Write a SELECT statement that will return data on customers in the state of Texas. In addition, the statement will return data about the salesperson assigned to the customer. This is done by joining the salesperson_id of the demo_customer table to the employee_id of demo_employee table. Display the customer_name, salesperson_id, last_name of the salesman (employee), and the commission the salesman (employee) has earned. Order the data by the value of the commission in descending order
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Lab_05_multipletablequeries - World Campus IST210 Lab # 5 :...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online