Practise with basic SQL using SQLite
Make sure you have correctly installed SQLite add-on on your machine. A description is found here.
Create a directory on your machine for holding the IS371 lab session files, say C:\IS371 or similar. Then download this zip file and unpack it in that directory. This should create a subdirectory IS371_lab1 containing six files.
Open SQLite GUI:
From the toolbar select
Database > Import
Select the files you just downloaded. You can select the file using
Select File button.
Please insert the data type for each column
according to the following figure:
Try to find the correct SQL statement for each of the following Queries:
Please use the following button to submit your SQL statements