Assignment Content
Navigate to the SQL Tutorial from W3Schools.
Complete the following SQL query commands practice tutorials listed down the left side of the page:
- SQL Joins
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Self Join
- SQL Union
- SQL Group By
- SQL Having
- SQL Exists
- SQL Any, All
- SQL Select Into
- SQL Insert Into Select
- SQL Case
- SQL Null Functions
- SQL Stored Procedures
Each SQL command practice tutorial includes a query of the Demo Database.
For each of the SQL commands above, indicate the syntax and show the resulting table from each query of the Demo Database.
Submit the syntax and results for each SQL command.
