IT163_Unit8.docx IT163 Unit 8 Assignment 1.The Name, City and State of all employee

IT163_Unit8.docx  IT163  Unit 8 Assignment     1.The Name, City and State of all employees that work for Scootney Books sorted by Name.  SELECT Employees.fname, Employees.lname, Publishers.city, Publishers.state  FROM Publishers INNER JOIN Employees ON Publishers.pub_id=Employees.pub_id  WHERE Publishers.pub_name=”Scootney books”;  2. Title of all books published in Boston, sorted by title.  SELECT Books.title  FROM Publishers INNER JOIN Books ON Publishers.pub_id=Books.pub_id  WHERE Publishers.city=”Boston”;    3. Name of all female authors & titles that wrote books after June 2010, sorted by name.  SELECT Authors.au_lname, Books.type, Books.pubdate  FROM Authors, BooksWHERE  Authors.au_sex="f" AND Books.type="romance" AND Books.pubdate<#6/1/2010#;  4. Full name of every employee that is a Marketing manager in order   SELECT Employees.fname, Employees.lname, Jobs.job_desc, [fname]+" "+[lname] AS [Full Name]  FROM Jobs INNER JOIN Employees ON jobs.job_id=Employees.job_id  WHERE jobs.job_desc="Marketing Manager";