You need to do the following;
This is to do with a fake drug/crime cases table.
- Create a table in Oracle SQL Database (Can use SQLdeveloper program to do it, upto you)
- Insert simple data into this table, you need to make up like 35 records (just random fake names/addresses etc.)
- Write simple queries like how many times a person's name comes up, or what nationality there are; amount of drug cases each year (annual), number of convicts between certain age bands, list the number of each type of drug case.