--Select examples

use MagazineSubscription

--basic select
SELECT CustLastName, CustFirstName, custPhone
FROM Customer

--Select *

SELECT * 
From Magazine

--Aliasing
SELECT CustLastName AS "Last Name" , CustFirstName AS "First Name", 
custPhone AS "Phone"
FROM Customer

--Order by 
SELECT CustLastName, CustFirstName, CustPhone
FROM Customer
ORDER BY CustLastName

SELECT CustLastName, CustFirstName, CustPhone
FROM Customer
ORDER BY CustLastName DESC

SELECT CustID, MagDetID, SubscriptionStart
FROM Subscription
ORDER BY CustID, SubscriptionStart

--ordering by relative column position
SELECT CustID, MagDetID, SubscriptionStart
FROM Subscription
ORDER BY 2, 3

--Distinct
SELECT MagID
From MagazineDetail

SELECT DISTINCT MagID
FROM MagazineDetail

--Where clause

SELECT * 
FROM Customer
WHERE CustCity='Seattle'

SELECT *
FROM MagazineDetail
WHERE SubscriptionPrice > 100
ORDER BY SubscriptionPrice DESC

SELECT * 
FROM Subscription
WHERE SubscriptionStart > '4/1/2006'

--Like
SELECT * 
FROM Customer
WHERE CustLastName LIKE 'D%'

SELECT *
FROM Customer
WHERE CustLastName Like '%an%'

--and or not
SELECT *
FROM Customer
WHERE CustLastName Like '%an%'
AND CustCity='Seattle'

SELECT *
FROM Customer
WHERE CustLastName Like '%an%'
OR CustCity='Seattle'

SELECT *
FROM Customer
Where Not CustCity = 'Seattle'

--Nulls
Select * 
FROM Subscription
WHERE SubscriptionEnd Is Null