5_output.txt - Query 1: Retrieve information about the...

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

View Full Document Right Arrow Icon
Sheet1 Page 1 Query 1: Retrieve information about the projects (title, status and whether archived or not) Solution: 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 Query 2: Retrieve the information about the investigators (first name, last name and organization) who have done more than one project. Solution: 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 Query 3: Retrieve the information of reviewers (first name and last name), investigators (first name and last name) for the project j Air Quality Research Project& . Also give the title and status of the project. Order by descending order of project title.
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

5_output.txt - Query 1: Retrieve information about the...

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