3_query.sql - 1.Retrieve information about the projects...

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

View Full Document Right Arrow Icon
Sheet1 Page 1 1.Retrieve information about the projects (title, status and whether archived or not) that have an J Optional& reviewer. Query: select title, project_status, archived from project P,reviews R where P.project_id = R.project_id and r.reviewer_role = 'optional' Result: TITLE PROJECT_STATUS ARCHIVED Online Shopping Compleated Archieved1 2)Retrieve the information about the investigators (first name, last name and organization) who have done more than one project. Query: select first_name,last_name, organization from investigator where ssn in ( select ssn from works_on having count(*) > 1 group by ssn ) Result: FIRST_NAME LAST_NAME ORGANIZATION Eden Naba ABC John Smith JSM 3)Retrieve the information of reviewers (first name and last name), investigators (first name and last name) for the project ± Air Quality Research Project& . Also give the title and status of the project. Order by descending order of project title. Query:
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 / 3

3_query.sql - 1.Retrieve information about the projects...

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