Help with selects
Date: 19 Mar 1999 04:05:20 GMT
Message-ID: <7csie0$bkm_at_butler.ac.BrockU.CA>
4.
Using the HEAT and SLAB tables, list the heat number, total steel weight and total slab weight for each heat between 227080 and 227100 inclusive.
5.
Using the HEAT and GRADE tables, list the grade code and the count of the
number of heat made of each grade.
6.
Using the HEAT and GRADE tables, list all of the grade codes and the
count of the number of heats made if any.
7.
Using the HEAT and GRADE tables, list all of the grade codes and the
count of the number of heats made if any where the ladle open time is
between 1/9/99 and 1/12/99.
8.
Using the SLAB table, list the heat number and last slab number and
weight of the last slab for heat between 227170 and 227200 inclusive.
9.
Using the SLAB table, list the heat number, slab number and slab volume
(length * width * thickness) heats between 227100 and 227102 inclusive.
Use the average of the head and tail widths.
10.
Using the HEAT table, list the heat number and time between heats at the
caster (open time this heat - close time previous heat) for heats opening
between 1/12/99 and 1/14/99.
umm... sorry for this huge spammy thing, but I need mass help making select statements to do these... can someone please help me?
The full assignment list is on
http://www.cosc.brocku.ca/~ktaylor/assign2.html
please don't send direct answers... just suggestions, or examples that would help... please, tho, help in any way if ya can! Received on Fri Mar 19 1999 - 05:05:20 CET