SQL Homework

SQL Homework - SQL Homework (due on 2/6/2008) (The...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
SQL Homework (due on 2/6/2008) (The solutions are NOT at the end) EXERCISE 1: From the table Employee, for each city, the id of the oldest employee and the date of birth. EXERCISE 2: For each customer, the customerid and the number of orders shipped after 1/1/1997 EXERCISE 3: For each customer, the customerid, the name (of the customer) and the number of orders shipped after 1/1/1997 EXERCISE 4 (HARD): For each order, its id, the customerid associated to the order and the amount of money paid by the customer for the order. Note: Send me an email with the 4 SQL queries, don’t hand in any paper!
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
SQL Exercises (The solutions are at the end) EXERCISE 1: For each territory, retrieve the territoryid, its description and the description of the region it belongs to EXERCISE 2: For each product, its id, its name and the name of the supplier company EXERCISE 3: For each employee, his/her id, and the number of territories assigned to him/ her. EXERCISE 4:
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

SQL Homework - SQL Homework (due on 2/6/2008) (The...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online