SQL FROM Clause
-------------------------


SELECT
   b.fullname
   , b.age
FROM
   bakers  b
WHERE
   b.age > 30;



SELECT
   b.fullname
   , r.episodeid
   , r.result
FROM
   bakers b
   , results r
WHERE
   b.baker = r.baker ;


Return the name and hometown of bakers who came in first in at least
two different technical challenges.


SELECT DISTINCT
   b.fullname
   , b.hometown
FROM
   bakers b
   , technicals t1
   , technicals t2
WHERE
   b.baker = t1.baker
   and b.baker = t2.baker
   and t1.rank = 1
   and t2.rank = 1
   and t1.episodeid > t2.episodeid;


Return name and hometown of all bakers who used chocolate in their
showstopper challenge of an episode and came first in that episode.


SELECT DISTINCT
   b.hometown
   , b.fullname
FROM
   bakers b
   , showstoppers ss
   , results r
WHERE
   b.baker = ss.baker
   and r.baker = ss.baker
   and r.episodeid = ss.episodeid
   and lower(ss.make) LIKE '%chocolate%'
   and r.result = 'star baker';

Return the fullname of bakers who used ginger in both a showstopper
and a signature challenge.


SELECT DISTINCT
   b.fullname
FROM
   bakers b
   , signatures s
   , showstoppers ss
WHERE
   b.baker = s.baker
   and b.baker = ss.baker
   and lower(s.make) LIKE '%ginger%'
   and lower(ss.make) LIKE '%ginger%'   ;