MALKIN

Click Here to get more at CommentYou.com

src="http://i345.photobucket.com/albums/p368/pbaffiliatebanners/July%2008%20Blue/pb_88x31_set1.gif"
alt="Image Hosting at Photobucket">

MALKIN

Click Here to get more at CommentYou.com

src="http://i345.photobucket.com/albums/p368/pbaffiliatebanners/July%2008%20Blue/pb_88x31_set1.gif"
alt="Image Hosting at Photobucket">

DATABASE2

SELECT companyname, MAX(price) AS presyo

FROM tblingredients AS i, tblvendors AS v, tblitems AS mi, tblmadewith AS mw

WHERE i.vendorid=v.vendorid AND i.ingredientid=mw.ingredientid AND mw.itemid=mi.itemid

GROUP BY v.vendorid, companyname;

SELECT DISTINCT (companyname)

FROM tblingredients AS i, tblvendors AS v, tblitems AS mi, tblmadewith AS mw

WHERE i.vendorid=v.vendorid AND i.ingredientid=mw.ingredientid AND mw.itemid=mi.itemid AND mi.name='Fruit Plate';

SELECT v2.companyname

FROM tblvendors AS v1, tblvendors AS v2

WHERE v1.vendorid=v2.referredby AND v1.companyname= 'Veggies_R_Us';

SELECT i.name,

m.name

FROM tblitems AS i, tblmeals AS m, tblpartof AS p

WHERE i.itemid=p.itemid AND p.mealid=m.mealid;

SELECT i.name

FROM tblingredients AS i, tblmadewith AS mw

WHERE i.ingredientid=mw.ingredientid AND inventory=quantity;

SELECT ingredientid

FROM tblingredients, tblvendors

WHERE name=companyname;

SELECT *

FROM tblmeals, tblpartof;

SELECT m.name AS meal, i.name AS item

FROM tblmeals AS m, tblpartof AS p, tblitems AS i

WHERE m.mealid=p.mealid AND

i.itemid=p.itemid;

SELECT *

FROM tblmeals AS m1, tblmeals AS m2;

SELECT m.name AS meal, i.name AS item

FROMtblmeals AS m, tblpartof AS p, tblitems AS i

WHERE i.itemid=p.itemid;

SELECT tblitems.name, ing.name

FROM tblitems,tblmadewith AS mw, tblingredients AS ing

WHERE tblitems.itemid=mw.itemid AND mw.ingredienti

d=ing.ingredientid AND 3*mw.quantity>ing.inventory;

SELECT a.name

FROM tblitems AS a, tblitems AS q

WHERE a.price>q.price AND q.name='Garden Salad';

SELECT DISTINCT (i.name)

FROM tblitems AS

a, tblitems AS q, tblmadewith AS m, tblingredients AS i

WHERE a.price>q.price AND q.name='Garden Salad' AND i.ingredientid=m.ingredientid AND m.itemid=a.itemid;

SELECT i1.name, COUNT(*) AS rank

FROM tblingredients AS i1, tblingredients AS i2

WHERE i1.name>=i2.name

GROUP BY i1.ingredientid, i1.name;

SELECT name

FROM tblingredients AS i INNER JOIN tblvendors AS v ON i.vendorid=v.vendorid

WHERE v.companyname='Veggies_R_Us';

SELECT i1.name

FROM tblitems AS i1 INNER JOIN tblitems AS i2 ON i1.price>i2.price

WHERE i2.name='Garden Salad';

SELECT companyname, i.vendorid, i.name

FROM tblvendors AS v INNER JOIN tblingredients AS i ON v.vendorid=i.vendorid;

DATABASE

SQL TABLES:




















































SQL STATEMENTS AND OUTPUTS:

SELECT i.name, m.quantity, d.name, d.unitprice, (d.unitprice*m.quantity) AS subtotal

FROM tblitems AS i, tblmadewith AS m, tblingredients AS d

WHERE i.itemid=m.itemid And i.name Like "fruit plate" And d.ingredientid=m.ingredientid;

SELECT tblvendors.vendorid, tblingredients.name, tblvendors.companyname

FROM tblingredients, tblvendors

WHERE tblingredients.vendorid=tblvendors.vendorid;

SELECT name

FROM tblingredients, tblvendors

WHERE tblingredients.vendorid=tblvendors.vendorid AND companyname='Veggies_R_Us';

SELECT tblstores.storeid, tblorders.price

FROM tblorders, tblstores

WHERE tblorders.storeid=tblstores.storeid AND state='CA';

SELECT state, SUM(price)

FROM tblstores, tblorders

WHERE tblstores.storeid=tblorders.storeid

GROUP BY state;

SELECT v.vendorid AS ["VENDOR ID"], name

FROM tblingredients AS i, tblvendorsAS v

WHERE i.vendorid=v.

vendorid And v.companynameIn ('Veggies_R_Us','SpringWater Supply')

ORDER BYv.vendorid;

SELECT DISTINCT mi.name, price

FROM tblingredients AS i, tblvendors AS v, tblitems AS mi, tblmadewith AS mw

WHERE i.vendori

d=v.vendorid AND i.ingredientid=mw.ingredientid AND mw.itemid=mi.itemid AND

companyname='Veggies_R_Us';