This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 4. Find the names of all Professors who teach a course which has a 2 somewhere in its course_id. Problem 3: SQL Subqueries Consider the following database schema: • Camera(manufacturer, model, type, price) • P&S(model, shutter_speed, zoom, internal_memory) • SLR(model, shutter_speed, internal_memory) Note that both P&S (point and shoot) and SLR (digital single lens reflex) are Cameras, identified by the type field. Write the following queries in SQL. Do not use aggregation functions. 1. Find the model of P&S's whose internal memory is lower than that of any SLR. 2. Find the manufacturer of the P&S with the fastest shutter speed. 3. Find the list of model-manufacturer pairs where the model in each pair is the most expensive model for the manufacturer....
View Full Document
- Spring '07
- Database schema, BCNF, Digital single-lens reflex camera, Single-lens reflex camera, digital single lens, fastest shutter speed