Description
Use Structured Query Language (SQL) to manage data.
Instructions
You must have the Access Database system installed for this assignment. You should have imported the Books2010 database into Access.
Using the schema in the Books2010 database, write SQL statements for these questions:
- The Name, City and State of all employees that work for Scootney Books
- Title of all books published in Boston
- Name of all female authors & titles that wrote romance books after June 2010
- Full name of every employee that is a Marketing manager in order< hint: fullname is lastname concatenated to firstname, separated by a blank.>
- All authors that received a royalty greater than 10
- Title and price of all books that sell for less than $20 written by Green
In a word document copy each of the questions in BOLD.
After each question, place the SQL statement in text.
After the text, place the screen shot of the execution from Access. Start a new page with the next question.
Explanation & Answer
Attached.
Using the schema in the Books2010 database, write SQL statements for these questions:
1. The Name, City and State of all employees that work for Scootney Books
SELECT Employees.fname, Employees.lname, Publishers.state, Publishers.pub_name
FROM Publishers LEFT JOIN Employees ON Publishers.pub_id = Employees.pub_id
WHERE (((Publishers.pub_na...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Normal People
by Sally Rooney
Twelve Years A Slave
by Solomon Northrup
The Old Man and the Sea
by Ernest Hemmingway
The President is Missing
by James Patterson, Bill Clinton
Les Miserables
by Victor Hugo
Animal Farm
by George Orwell
Narrative of the Life of Frederick Douglass
by Frederick Douglass
The Aftermath
by Rhidian Brook