Exercise
DB SQL
Last update 1999.03.02 (1998.03.017 ) [1998.03.08 ]





Exercise: SQL, Structured Query Language

Fetch the semester 6 project database from previous exercise.

First study the examples given in the lecture.

Make your own SQL queries using the 'Foresporgsel' scheme in Access.

  1. List all available project types i alphabetic order
  2. Count the number of project groups
  3. List for each student (in alphabetic order) group belonging and corresponding project.


Per Christiansson