DBM 294 Week 4 Individual Assignment Data Query Language
Extend the SQL script you developed for the week three individual
Write additional SQL commands in your script that demonstrate use of
the following keywords and techniques (one separate command to
demonstrate each bullet). These commands should interact with the
tables you have been creating.
- INNER JOIN
- OUTER JOIN
- ORDER BY
- GROUP BY
- Aggregate function: SUM
- Aggregate function: AVG
Using the Assignment Files tab:
Submit your SQL script.
Submit a document containing screen shots of each SQL command
and the corresponding output.
Questions & Answers
Have a Question?
Be the first to ask a question about this.