Monday, February 5, 2018

Sql 1 PM class

Use Community_Assist;

Select * from Person
Order by PersonLastName;

Select PersonFirstName, PersonLastName, PersonEmail
From Person
Order by PersonLastName;

Select PersonFirstName, PersonLastName, PersonEmail
From Person
Where PersonLastName='Brown';

Select * from Donation
Where DonationDate between'8/10/2015' and '8/11/2015';

Select * from Donation
Where DonationAmount > 1000;

Select * from Employee;

Select PersonFirstName, PersonLastName, EmployeeHireDate,
EmployeeAnnualSalary
From Person
inner join Employee
On Person.PersonKey=Employee.PersonKey;

Insert into Person(
PersonLastName, 
PersonFirstName, 
PersonEmail, 
PersonEntryDate)
Values('Foles',
'Nick',
'nick.foles@gmail.com'
,getDate())


Insert into PersonAddress(PersonAddressApt,
PersonAddressStreet, PersonAddressCity, 
PersonAddressState, PersonAddressZip, PersonKey)
Values(null,'10010 Elsewhere','Seattle','Wa', '98100', 130)

Insert into Donation(PersonKey, DonationDate, 
DonationAmount)
Values(130, GetDate(), 1000000)

Select * from Donation

Select * from PersonAddress

Select * from Person

No comments:

Post a Comment