More sample Queries w.r.t. the YV database in Ullman's book

List the name and salary of all employess whose manager is David.
What items did the sports department buy on 01/20/96 ?
List all items which have been ordered from customer A on June, 1, 1996.
List all items, their suppliers and the departments selling these items which have been ordered from customer A on June, 1, 1996.
Give the pricelist of all items in the toys department.
List all orders made on October 12th from the toys department.
Who was the customer who bought cloth from sports department?
List addresses of customers who placed an order on July 1st, 1995.
List names of all employees in departments that carry trees.
The Board of Directors wants to know who is the manager of the department that sold item#=1247 to customer Jack Jones.
List all the dates in which Peter bought exactly 12 donuts.
List the addresses of all suppliers who supply electric motor.
List the names of all customers who ordered item#200.
Who is john's manager?
Give the order number and supplier names for all the items in the toys dept.
List all managers whose dept. contains an item whose price is $2.75.
List all customers that placed an order which bought at least one item from every dept.
List all customers who bought at least one item from every dept.
Give the clothing price which John bought from the sport dept.
List all the customer names who bought meat in Jan. 19 from the food dept.