Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 6.1.2
- a)
- SELECT department_id, department_name, location_id, city
- FROM departments JOIN locations USING(location_id)
- b)
- SELECT d.department_id, d.department_name, l.location_id, l.city
- FROM departments d JOIN locations l ON(d.location_id=l.location_id)
- c)
- SELECT d.department_id, d.department_name, l.location_id, l.city
- FROM departments d, locations l
- WHERE d.location_id=l.location_id
- 6.1.3
- a)
- SELECT department_id, department_name, location_id, city
- FROM departments JOIN locations USING(location_id)
- WHERE department_id IN(20,50)
- b)
- SELECT d.department_id, d.department_name, l.location_id, l.city
- FROM departments d JOIN locations l ON(d.location_id=l.location_id)
- WHERE d.department_id IN(20,50)
- c)
- SELECT d.department_id, d.department_name, l.location_id, l.city
- FROM departments d, locations l
- WHERE d.location_id=l.location_id AND d.department_id IN (20,50)
- 6.2.1.
- a)
- SELECT d.department_id, d.department_name, l.location_id, l.city
- FROM departments d JOIN locations l ON(d.location_id=l.location_id)
- WHERE d.location_id=1400
- b)
- SELECT d.department_id, d.department_name, l.location_id, l.city
- FROM departments d, locations l
- WHERE d.location_id=l.location_id AND d.location_id=1400
- 6.2.2.
- a)
- SELECT pli.song_id, tl.cd_number, cds.title, pli.comments
- FROM d_play_list_items pli JOIN d_track_listings tl ON(pli.song_id=tl.song_id) JOIN d_cds cds ON(tl.cd_number=cds.cd_number)
- b)
- SELECT pli.song_id, tl.cd_number, cds.title, pli.comments
- FROM d_play_list_items pli, d_track_listings tl, d_cds cds
- WHERE pli.song_id=tl.song_id AND tl.cd_number=cds.cd_number
- 6.2.4.
- a)
- SELECT c.country_name, r.region_id, r.region_name
- FROM countries c JOIN regions r ON(c.region_id=r.region_id)
- WHERE r.region_name='Americas'
- b)
- SELECT c.country_name, r.region_id, r.region_name
- FROM countries c, regions r
- WHERE c.region_id=r.region_id AND r.region_name='Americas'
- 6.2.5.
- a)
- SELECT e.first_name, e.last_name, e.hire_date, j.job_id, j.job_title, j.max_salary
- FROM employees e JOIN jobs j ON(e.job_id=j.job_id)
- WHERE j.max_salary>12000
- b)
- SELECT e.first_name, e.last_name, e.hire_date, j.job_id, j.job_title, j.max_salary
- FROM employees e, jobs j
- WHERE e.job_id=j.job_id AND j.max_salary>12000
- 6.2.8
- SELECT l.location_id, l.city, d.department_name
- FROM locations l, departments d
- WHERE l.location_id=d.location_id AND l.country_id='CA'
- 6.2.9
- SELECT d.manager_id, d.department_id, d.department_name, e.first_name, e.last_name
- FROM departments d, employees e
- WHERE d.department_id=e.department_id AND d.department_id IN(80,90,110,190)
- 6.2.10
- a)
- SELECT employee_id, last_name, department_id, department_name, hire_date
- FROM departments JOIN employees USING(department_id)
- WHERE hire_date='07-Jun-1994'
- b)
- SELECT e.employee_id, e.last_name, d.department_id, d.department_name, e.hire_date
- FROM departments d JOIN employees e ON(d.department_id=e.department_id)
- WHERE e.hire_date='07-Jun-1994'
- c)
- SELECT e.employee_id, e.last_name, d.department_id, d.department_name, e.hire_date
- FROM departments d, employees e
- WHERE d.department_id=e.department_id AND e.hire_date='07-Jun-1994'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement