I need 3 sql help

[Skido]

Data Request 1:
Find customers who placed orders on or after May 1, 1998. Show distinct
company names of these customers.

Data Request 2:
Using the query you generated in Data Request 1 as part of a nested SQL
Select query, find customers who placed orders in April 1998 but not on or
after May 1, 1998. Show distinct company names of these customers.

Data Request 3:
Calculate total price for each completed order and sort based on total price
so that the ordering is from highest to lowest dollar amount. Show the order
ID column and the total price column labeled as “Total Priceâ€.

 

[Rob Parker]

This is not the "homework help" newsgroup.

And even if it was, you have not provided sufficient information for anyone
to help you.

Goodbye,

Rob

 

[John W. Vinson]

Data Request 1:
Find customers who placed orders on or after May 1, 1998. Show distinct
company names of these customers.

Data Request 2:
Using the query you generated in Data Request 1 as part of a nested SQL
Select query, find customers who placed orders in April 1998 but not on or
after May 1, 1998. Show distinct company names of these customers.

Data Request 3:
Calculate total price for each completed order and sort based on total price
so that the ordering is from highest to lowest dollar amount. Show the order
ID column and the total price column labeled as “Total Price”.

That's downright rude, skido. You're posting what are pretty obviously class
homework questions, with no evidence whatsoever that you've tried anything or
even thought about the question, and you have not posted any description of
your table structure.

If you have some *reasonable* explanation post back. Otherwise, study your
class materials and please do your own work, rather than asking unpaid
volunteers to save you the effort of thinking.