/* Lab 2
   Philip Bock */

use Pubs;

-- Question 1
select au_lname, phone from authors;

-- Question 2
select stor_name 'Store Name', city 'City', state 'State' from stores;

-- Question 3
select title_id 'Title', price 'Price', advance 'Advance', royalty 'Royalty' from titles;

-- Question 4
select fname + ' ' + lname 'Name' from employee where hire_date >= 'January 1, 1991';


use Northwind;

-- Question 5
select RequiredDate, ShippedDate, EmployeeID from Orders where CustomerID = 'BERGS';

-- Question 6
select CompanyName, Address, City, Region from Customers where CompanyName like 'Fr%';

-- Question 7
select OrderDate 'Order Date', ShippedDate 'Shipped Date', OrderID 'Order ID' from Orders
where OrderDate between 'July 4, 1996' and 'September 3, 1996' order by OrderDate;

-- Question 8
select FirstName, LastName from Employees where City in ('London', 'Seattle')
order by LastName, FirstName;

-- Question 9
select City, CompanyName, Region from Suppliers where Region is null
order by City, CompanyName;

-- Question 10
select OrderID 'Order ID', (UnitPrice * Quantity) - Discount 'Total Cost' from [Order Details];
