The queries are categorised into topics and put into saperate files.
First of all one should run the ** sqlscript.sql **
It will create all the tables that are required for running the queries.
The sequence in which one should go through the codes:
- Select
- RestrictingAndSorting
- SingleRowFunction
- NullComparisionFunctions
- ConversionFunction
- ConditionalExpressions
- AggregatedData
- EquiJoins
- NonEquiJoins
- OuterJoins
- Subqueries
I Will also update a PLSQL tution in the similar manner. ** Peace.. **