Activity: SQL Subqueries and quantifiers
(no submission)Purpose:
- Be familiar with database queries
- Practice writing and interpreting SQL
- Get ready to work on homework assignment and course project
You may make a copy of a worksheet and complete this activity, or simply type your answers in any text editor.
You may work alone or with at most 2 other students (max size=3) in this course.
Use the following schema.
Product (maker, model, type) -- maker is foreign key to Manufacturer(maker) PC (model, speed, ram, hd, price) Laptop (model, speed, ram, hd, screen, price) Printer (model, color, type, price)
Alternatively, you may import Product-Laptop-PC-Printer.sql into your database server.
You may find subqueries helpful.
Write SQL queries to solve at least 5 of the following problems.
- Find the makers of PC's with a speed of at least 3.0
- Find the printers with the highest price
- Find the laptops whose speed is slower than that of any PC
- Find the maker of the color printer with the lowest price
- Consider the manufacturers that make printers, find the average hard disk size of a PC these manufacturers make
- List all laptops with price greater than the average price of PC's
- Find the average price of PC's and laptops made by manufacturer "EEE"
Copyright © 2026 Upsorn Praphamontripong
Released under the
CC-BY-NC-SA 4.0 license.
Last updated 2026-02-15 15:31