This preview shows pages 1–3. 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: 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
This note was uploaded on 02/17/2012 for the course CS 411 taught by Professor Winslett during the Spring '07 term at University of Illinois at Urbana–Champaign.
- Spring '07