Sql Hw

1. SELECT PARTNUMB, PARTDESC
FROM PART Query1 | PARTNUMB | PARTDESC | AX12 | IRON | CX11 | MIXER |
WHERE UNONHAND BETWEEN 100 AND 200

2. SELECT PARTNUMB, PARTDESC, (UNITPRCE*UNONHAND) ONHANDVALUE
FROM PART
WHERE VALUE >= 1000

Query1 | PARTNUMB | PARTDESC | ONHANDVALUE | AX12 | IRON | $1,866.80 | BH22 | TOASTER | $3,320.25 | BT04 | STOVE | $4,432.89 | BZ66 | WASHER | $16,221.40 | CB03 | BIKE | $8,250.00 | CX11 | MIXER | $6,490.40 | CZ81 | WEIGHTS | $22,669.92 |

3. SELECT CUSTNUMB, CUSTNAME
FROM CUSTOMER
WHERE CUSTNAME LIKE 'Nelson,*'

Query1 | CUSTNUMB | CUSTNAME | 522 | Nelson, Mary |

4. SELECT *
FROM PART
GROUP BY ITEMCLSS
ORDER BY PARTNUMB

SELECT PART.PARTNUMB, PART.PARTDESC, PART.ITEMCLSS, PART.WRHSNUMB, PART.UNITPRCE
FROM PART
ORDER BY PART.ITEMCLSS, PART.PARTNUMB

Query1 | PARTNUMB | PARTDESC | ITEMCLSS | WRHSNUMB | UNITPRCE | BT04 | STOVE | AP | 2 | $402.99 | BZ66 | WASHER | AP | 3 | $311.95 | AX12 | IRON | HW | 3 | $17.95 | BH22 | TOASTER | HW | 3 | $34.95 | CA14 | SKILLET | HW | 3 | $19.95 | CX11 | MIXER | HW | 3 | $57.95 | AZ52 | SKATES | SG | 2 | $24.95 | BA74 | BASEBALL | SG | 1 | $4.95 | CB03 | BIKE | SG | 1 | $187.50 | CZ81 | WEIGHTS | SG | 2 | $108.99 |

5. SELECT SUM(BALANCE) AS TOTAL
FROM CUSTOMER
WHERE SLSRNUMB = 12

Query1 | TOTAL | $451.35 |

6. SELECT DISTINCT SLSRNUMB, SUM(BALANCE) AS TOTAL
FROM CUSTOMER
GROUP BY SLSRNUMB

Query1 | SLSRNUMB | TOTAL | 3 | $1,903.00 | 6 | $590.45 | 12 | $451.35 |

SELECT DISTINCT SLSRNUMB, SUM(BALANCE) AS TOTAL
FROM CUSTOMER
GROUP BY SLSRNUMB
HAVING COUNT(CUSTNUMB) >= 4

Query1 | SLSRNUMB | TOTAL | 6 | $590.45 |

7. SELECT ORDERS.ORDNUMB, ORDDTE, ORDLNE.PARTNUMB, ORDLNE.QUOTPRCE
FROM ORDERS, ORDLNE
WHERE ORDERS.ORDNUMB = ORDLNE.ORDNUMB

Query1 | ORDNUMB | ORDDTE | PARTNUMB | QUOTPRCE | 12489 | 9/2/1991 | AX12 | $14.95 | 12491 | 9/2/1991 | BT04 | $402.99 | 12491