Week 9

Post date: Oct 26, 2018 12:48:33 PM

Chapter 5: More SQL: Complex Queries, Triggers, Views, and Schema Modifications

More complex SQL retrieval queries

Exercises set #1: Wildcard and Special operators

Exercises set #2: Aggregate Functions

Exercises set #3: Subqueries (Interesting ones: 12-19)

Lab Exercise #1:

Solution

another way is the following

b) select class from Outcomes, Ships where name = ship and result = "sunk"

Lab Exercise #2:

Solution