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
Monday, February 5, 2018
Sql 1 PM class
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment