Week 1 Challenge

These all use the Pubs database

1. Display all of the author's firstname, lastname, and city (authors table)

2. Show just the state of all the authors (authors table)

3. Show the order number, qty and qty plus 2 for each sale (sales table)

4. Show all of the distinct stor_id's from the sales table.