SQL query could anyone help?

[gershon]

Given the following database structure, write an SQL query to retrieve a list of order ids, ordered prior to June 1st, 2003, and the total amount of the order including shipping.

Orders:
id
date
shipping_amount
order_status
customer_id

OrderItems:
id
order_id
product_id
price
quantity

could anyone figure this one out?

[dalecosp]

Originally posted by gershon
Given the following database structure, write an SQL query to retrieve a list of order ids, ordered prior to June 1st, 2003, and the total amount of the order including shipping.

Orders:
id
date
shipping_amount
order_status
customer_id

OrderItems:
id
order_id
product_id
price
quantity

could anyone figure this one out?

Sure. I'd ask in the database forum. But isn't your assignment past due by now? 😉

More seriously, try here.