SQLite Forum

Help to find a specific result
Login
Hi,
So I have a database with 3 tables:
-producer: nprod, last name, first name, region
-harvest: nprod, nwine, quantity, year
-wine: nwine, wine, proof


Some examples of these values:
-nprod: unique number assigned to a producer
-nwine: unique number assigned to a wine
These last two are mainly used for natural joins but also to count producers & wines with count().
-last name: Michon
-first name: Philippe
-region: Alsace
-quantity: quantity harvested of a specific wine
-year: 2002
-wine: Beaujolais (note: there can be a wine that appears in multiple regions)
-proof: 12°

I have to find the commands in SQLite3 to get these specific results:

1. Find all the wines that have been collected by the Alsace region (region='Alsace').

2. Find the producers who have harvested all the wines from their region.

Thank you for your help.