This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: ) Queries The output schema for the query is given in parentheses following the query specification. 1. Which accounts have only one patient associated with it? (accountID, lastName, firstName, balance) 2. Which doctors have never made a diagnosis of ‘High blood pressure’? (doctorID, drName) 3. Which patients have had visits with the minimum visit charge? (firstName, lastName, vMonth, vDay, vYear, charge) 4. Which doctors have diagnosed all of the patients who were born in the timeframe from 1965 to 1975? (doctorID, drName, degreeYear) CSE 412/598 2 SQL Study Problems...
View Full Document
This note was uploaded on 12/11/2009 for the course CSE 412 taught by Professor Davulcu,h during the Fall '08 term at ASU.
- Fall '08