I took database as elective this summer but i'm in trouble please help
I have this assignment i have to finish tonight
--------------------------------------------
The id number of all customers who have placed 9 or more orders or who placed a single order of more than $70,000
A description of any inventory item that has sold less than 2000 units
The ID of any customer who has never purchased a flaming widget.
A list of all customers and the dollar total of their orders
The order number of any order where both flaming and econo widgets were sold
The order number of any order where flaming widgets but not econo widgets were sold.
The name and phone of any customer who placed nine or more orders
The name and phone of any customer who placed an order for a Flaming Widget.
===============================
you dont have to solve all of them
this is the tables
customers=it has>> id-name-customertypr-add-phone-zipcode-etc.
-----
inventory==has=> discription-cost-price-onhand-onorder-allocated-itm
---
saleorder==>has>>ordernm-orerdate-shipdate-shipvia-orderdetal-salsagent
=====
soldetail==>has=>ordernum-linenum-partno-qty-cost-price