Section Week 11: Variations in Select Queries

Steps

1. Chinook Database Schema
   
2. Create a database named 507_Section_11
3. Run this command
   • Mac Users: psql 507_Section_11 -f Chinook_PostgreSql_utf8.sql
   • Windows Users: psql 507_Section_11 postgres -f Chinook_PostgreSql_utf8.sql
4. Edit a step in chinook_database.py, run the file, and repeat
   • Some questions to consider:
     • What table(s) do you need to get data from?
     • What fields in each table do you need to get data from?

References

1. SELECT: https://www.postgresql.org/docs/10/static/sql-select.html
2. Aggregate Functions: https://www.postgresql.org/docs/current/static/functions-aggregate.html
3. String Functions: https://www.postgresql.org/docs/current/static/functions-string.html
4. Pattern Matching: https://www.postgresql.org/docs/8.0/static/functions-matching.html

Attributions:

• Chinook_PostgreSQl.sql from Chinook Database
• Chinook Database Schema from Chinook Database Documentation