DBM 294 Week 4 Individual Assignment Data Query Language


Ask a Question

DBM 294 Week 4 Individual Assignment Data Query Language

Sale price $15.00 Regular price $30.00

DBM 294 Week 4 Individual Assignment Data Query Language

 

Instructions:

Extend the SQL script you developed for the week three individual

assignment.

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
  • Subquery

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.

Ask a Question