Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Week 2.1 appliance.mdb
- C
- SELECT AVG(KOSTEN) AS KOSTEN
- FROM ONDERDEEL
- WHERE LEVERANCIERSNUMMER = '3728'
- AND ONDERDEELTYPE = 'MOTOREN'
- F
- SELECT Afnemersnaam, SUM(PRIJS) AS Prijs
- FROM AFNEMER, APPARAAT
- WHERE AFNEMER.AFNEMERSNUMMER=APPARAAT.AFNEMERSNUMMER
- AND AFNEMER.LAND="Venezuela"
- OR AFNEMER.LAND="Argentina"
- OR AFNEMER.LAND="Mexico"
- GROUP BY AFNEMERSNAAM;
- I
- SELECT CONTROLEURSNAAM
- FROM CONTROLEUR
- WHERE SALARIS>(SELECT MAX(SALARIS)
- FROM CONTROLEUR
- WHERE DATUMINDIENST > #31-12-2001#
- AND DATUMINDIENST < #01-01-2003#)
- ORDER BY SALARIS;
- Week 2.2 cruise ned.mdb
- E
- SELECT AVG(BRUTOGEWICHT) AS Gewicht
- FROM SCHIP
- WHERE SCHEEPSBOUWER="Ace"
- AND BOUWJAAR > #31-12-1999#
- G
- SELECT LAND, SUM(AANTALLIGPLAATSEN) AS Aantal
- FROM HAVEN
- GROUP BY LAND
- ORDER BY 2 DESC
- K
- SELECT Passagiernaam, Huisadres, Telefoon
- FROM PASSAGIER, REIS, CRUISE, SCHIP
- WHERE PASSAGIER.PASSAGIERNUMMER=REIS.PASSAGIERNUMMER
- AND REIS.CRUISENUMMER=CRUISE.CRUISENUMMER
- AND CRUISE.SCHEEPSNUMMER=SCHIP.SCHEEPSNUMMER
- AND SCHEEPSNAAM="The Spirit of Nashville"
- AND VERTREKDATUM>=#01-07-2003#;
Add Comment
Please, Sign In to add comment