International Information Technology University, Information Systems Department
Lab Work 5. QUERYING THE DATABASE
4 March, 10 am
INTRODUCTION
This exercise will cover a variety of queries you can accomplish using SQL’s
SELECT statement. If you have completed Exercises 1 and 2 then your database
should contain tables for Artist and CD records. In order to add some variety for the
queries, we shou
ld add a few more CDs. If you’d like more practice with INSERT
and UPDATE operations then try to match your tables to these:
SELECT * FROM Artist;
