SQL labor3 output

+------------+| |+------------+| 3. feladat |+------------++---------+-------------------------------------+------------+----------------------+----------+------+-----------------------+------+| VIDEOID | TITLE | APPEARANCE | DIRECTOR | DURATION | FEE | COMMENTLINE | TYPE |+---------+-------------------------------------+------------+----------------------+----------+------+-----------------------+------+| 10000 | Lock, Stock And Two Smoking Barrels | 2008-03-02 | Guy Ritchie | 120 | 450 | Angol, szinkronizált | B || 10001 | Dogma | 2009-03-02 | Kevin Smith | 130 | 450 | | D || 10002 | Clerks | 2004-03-02 | Kevin Smith | 95 | 250 | ff. | B || 10003 | Gladiator | 2010-03-02 | Ridley Scott | 150 | 600 | Oscar-díjas | D || 10004 | Gladiator | 2002-03-02 | Rowdy Herrington | 101 | 250 | Akció | B || 10005 | The English Patient | 2007-03-02 | Anthony Minghella | 160 | 500 | Oscar-díjas | D || 10006 | Kandi Kamera+ | 2016-11-02 | - | 25 | 150 | rejtett felvételek | B || 10007 | A botkormányos 2. | 2016-06-02 | Kovi | 75 | 750 | | D || 10008 | Le Dernier Combat | 2016-03-02 | Francis Ford Coppola | 120 | 600 | Oscar-díjas | B || 10009 | Atlantis | 2015-09-02 | George Lucas | 120 | 500 | Klasszikus | D || 10010 | Subway | 2008-03-02 | Luc Besson | 110 | 800 | | B || 10011 | Le Grande Bleu | 2006-03-02 | James Cameron | 130 | 200 | | B || 10012 | Nikita | 2016-03-02 | Michael Curtiz | 115 | 400 | | B || 10013 | Leon | 2009-03-02 | Sam Mendes | 120 | 600 | Oscar dijas | D || 10014 | Fifth Element | 2019-03-02 | Kenneth Branagh | 80 | 600 | Alapmű | D || 10015 | Jeanne d'Arc | 2015-03-02 | Martin Scorsese | 60 | 400 | Kihagyhatatlan | D || 10016 | Le Transporteur | 2016-03-02 | Stanley Kubrick | 60 | 400 | | D |+---------+-------------------------------------+------------+----------------------+----------+------+-----------------------+------++------------+| |+------------+| 4. feladat |+------------++-------------------------------------+----------------------+| TITLE | DIRECTOR |+-------------------------------------+----------------------+| Lock, Stock And Two Smoking Barrels | Guy Ritchie || Dogma | Kevin Smith || Clerks | Kevin Smith || Gladiator | Ridley Scott || Gladiator | Rowdy Herrington || The English Patient | Anthony Minghella || Kandi Kamera+ | - || A botkormányos 2. | Kovi || Le Dernier Combat | Francis Ford Coppola || Atlantis | George Lucas || Subway | Luc Besson || Le Grande Bleu | James Cameron || Nikita | Michael Curtiz || Leon | Sam Mendes || Fifth Element | Kenneth Branagh || Jeanne d'Arc | Martin Scorsese || Le Transporteur | Stanley Kubrick |+-------------------------------------+----------------------++-------------------------------------+----------------------+| title | director |+-------------------------------------+----------------------+| Lock, Stock And Two Smoking Barrels | Guy Ritchie || Dogma | Kevin Smith || Clerks | Kevin Smith || Gladiator | Ridley Scott || Gladiator | Rowdy Herrington || The English Patient | Anthony Minghella || Kandi Kamera+ | - || A botkormányos 2. | Kovi || Le Dernier Combat | Francis Ford Coppola || Atlantis | George Lucas || Subway | Luc Besson || Le Grande Bleu | James Cameron || Nikita | Michael Curtiz || Leon | Sam Mendes || Fifth Element | Kenneth Branagh || Jeanne d'Arc | Martin Scorsese || Le Transporteur | Stanley Kubrick |+-------------------------------------+----------------------++------------+| |+------------+| 5. feladat |+------------++-------------------------------------+----------------------+------+| TITLE | DIRECTOR | type |+-------------------------------------+----------------------+------+| Lock, Stock And Two Smoking Barrels | Guy Ritchie | :) || Dogma | Kevin Smith | :( || Clerks | Kevin Smith | :) || Gladiator | Ridley Scott | :( || Gladiator | Rowdy Herrington | :) || The English Patient | Anthony Minghella | :( || Kandi Kamera+ | - | :) || A botkormányos 2. | Kovi | :( || Le Dernier Combat | Francis Ford Coppola | :) || Atlantis | George Lucas | :( || Subway | Luc Besson | :) || Le Grande Bleu | James Cameron | :) || Nikita | Michael Curtiz | :) || Leon | Sam Mendes | :( || Fifth Element | Kenneth Branagh | :( || Jeanne d'Arc | Martin Scorsese | :( || Le Transporteur | Stanley Kubrick | :( |+-------------------------------------+----------------------+------++------------+| |+------------+| 6. feladat |+------------++---------+-------------------------------------+------------------+----------+------+| VIDEOID | TITLE | DIRECTOR | DURATION | FEE |+---------+-------------------------------------+------------------+----------+------+| 10000 | Lock, Stock And Two Smoking Barrels | Guy Ritchie | 120 | 450 || 10001 | Dogma | Kevin Smith | 130 | 450 || 10002 | Clerks | Kevin Smith | 95 | 250 || 10004 | Gladiator | Rowdy Herrington | 101 | 250 || 10011 | Le Grande Bleu | James Cameron | 130 | 200 || 10012 | Nikita | Michael Curtiz | 115 | 400 |+---------+-------------------------------------+------------------+----------+------++------------+| |+------------+| 7. feladat |+------------++------------+----------+------------------+| WHEN | MEMBERID | NAME |+------------+----------+------------------+| 2017-02-18 | 10016 | Al Bundy || 2017-02-27 | 10015 | Vito Corleone || 2017-02-25 | 10014 | Kovács I. Béla || 2017-03-01 | 10013 | Johnny B. Good || 2016-06-21 | 10012 | Conan O'Bryan || 2016-09-29 | 10014 | Kovács I. Béla || 2014-11-06 | 10013 | Johnny B. Good || 2017-01-21 | 10016 | Al Bundy || 2016-12-09 | 10015 | Vito Corleone || 2016-06-08 | 10001 | Nagy István || 2016-07-21 | 10013 | Johnny B. Good || 2016-09-01 | 10003 | Nagy Istvan || 2016-12-07 | 10001 | Nagy István || 2016-04-24 | 10002 | Kiss Károly || 2016-06-30 | 10006 | Vörös Piroska || 2016-07-24 | 10000 | Kovács Károly || 2016-09-02 | 10016 | Al Bundy || 2017-01-18 | 10003 | Nagy Istvan || 2015-11-05 | 10006 | Vörös Piroska || 2017-02-15 | 10008 | Első Imre || 2016-12-09 | 10008 | Első Imre || 2017-01-16 | 10004 | Király István || 2017-02-18 | 10005 | Fehér Barna || 2016-12-09 | 10006 | Vörös Piroska || 2016-12-28 | 10005 | Fehér Barna || 2017-02-05 | 10001 | Nagy István || 2017-02-27 | 10005 | Fehér Barna || 2016-12-09 | 10006 | Vörös Piroska || 2016-12-10 | 10006 | Vörös Piroska || 2017-01-08 | 10002 | Kiss Károly || 2017-02-10 | 10004 | Király István || 2017-02-22 | 10013 | Johnny B. Good |+------------+----------+------------------++------------+| |+------------+| 8. feladat |+------------++---------+-------------------------------------+------------+| VIDEOID | TITLE | WHEN |+---------+-------------------------------------+------------+| 10010 | Subway | 2017-03-01 || 10013 | Leon | 2017-02-27 || 10005 | The English Patient | 2017-02-27 || 10011 | Le Grande Bleu | 2017-02-25 || 10007 | A botkormányos 2. | 2017-02-22 || 10016 | Le Transporteur | 2017-02-18 || 10003 | Gladiator | 2017-02-18 || 10002 | Clerks | 2017-02-15 || 10007 | A botkormányos 2. | 2017-02-10 || 10005 | The English Patient | 2017-02-05 || 10010 | Subway | 2017-01-21 || 10001 | Dogma | 2017-01-18 || 10003 | Gladiator | 2017-01-16 || 10007 | A botkormányos 2. | 2017-01-08 || 10005 | The English Patient | 2016-12-28 || 10007 | A botkormányos 2. | 2016-12-10 || 10011 | Le Grande Bleu | 2016-12-09 || 10003 | Gladiator | 2016-12-09 || 10004 | Gladiator | 2016-12-09 || 10006 | Kandi Kamera+ | 2016-12-09 || 10000 | Lock, Stock And Two Smoking Barrels | 2016-12-07 || 10016 | Le Transporteur | 2016-09-29 || 10001 | Dogma | 2016-09-02 || 10000 | Lock, Stock And Two Smoking Barrels | 2016-09-01 || 10001 | Dogma | 2016-07-24 || 10000 | Lock, Stock And Two Smoking Barrels | 2016-07-21 || 10001 | Dogma | 2016-06-30 || 10013 | Leon | 2016-06-21 || 10000 | Lock, Stock And Two Smoking Barrels | 2016-06-08 || 10001 | Dogma | 2016-04-24 || 10002 | Clerks | 2015-11-05 || 10009 | Atlantis | 2014-11-06 || 10008 | Le Dernier Combat | SOHA || 10012 | Nikita | SOHA || 10014 | Fifth Element | SOHA || 10015 | Jeanne d'Arc | SOHA |+---------+-------------------------------------+------------++------------+| |+------------+| 9. feladat |+------------++---------+-------------------------------------+------------+| VIDEOID | TITLE | WHEN |+---------+-------------------------------------+------------+| 10013 | Leon | 2017-02-27 || 10005 | The English Patient | 2017-02-27 || 10007 | A botkormányos 2. | 2017-02-22 || 10016 | Le Transporteur | 2017-02-18 || 10003 | Gladiator | 2017-02-18 || 10007 | A botkormányos 2. | 2017-02-10 || 10005 | The English Patient | 2017-02-05 || 10001 | Dogma | 2017-01-18 || 10003 | Gladiator | 2017-01-16 || 10007 | A botkormányos 2. | 2017-01-08 || 10005 | The English Patient | 2016-12-28 || 10007 | A botkormányos 2. | 2016-12-10 || 10003 | Gladiator | 2016-12-09 || 10000 | Lock, Stock And Two Smoking Barrels | SOHA || 10002 | Clerks | SOHA || 10004 | Gladiator | SOHA || 10006 | Kandi Kamera+ | SOHA || 10008 | Le Dernier Combat | SOHA || 10009 | Atlantis | SOHA || 10010 | Subway | SOHA || 10011 | Le Grande Bleu | SOHA || 10012 | Nikita | SOHA || 10014 | Fifth Element | SOHA || 10015 | Jeanne d'Arc | SOHA |+---------+-------------------------------------+------------++-------------+| |+-------------+| 10. feladat |+-------------++----------+------------------+---------------+| MEMBERID | NAME | SUM(DURATION) |+----------+------------------+---------------+| 10012 | Conan O'Bryan | 120 || 10000 | Kovács Károly | 130 || 10014 | Kovács I. Béla | 190 || 10002 | Kiss Károly | 205 || 10004 | Király István | 225 || 10008 | Első Imre | 245 || 10015 | Vito Corleone | 250 || 10003 | Nagy Istvan | 250 || 10016 | Al Bundy | 300 || 10001 | Nagy István | 400 || 10013 | Johnny B. Good | 425 || 10006 | Vörös Piroska | 426 || 10005 | Fehér Barna | 470 |+----------+------------------+---------------++-------------+| |+-------------+| 11. feladat |+-------------++----------+-------------------+------------+| MEMBERID | NAME | SUM_LENGTH |+----------+-------------------+------------+| 10007 | Könyves Kálmán | NULL || 10015 | Vito Corleone | 250 |+----------+-------------------+------------++-------------+| |+-------------+| 12. feladat |+-------------++---------+-------------------------------------+----------+------------------+-------------+| videoid | title | memberid | name | dateofbirth |+---------+-------------------------------------+----------+------------------+-------------+| 10000 | Lock, Stock And Two Smoking Barrels | 10013 | Johnny B. Good | 1978-03-02 || 10001 | Dogma | 10002 | Kiss Károly | 1978-03-02 || 10002 | Clerks | 10006 | Vörös Piroska | 1989-02-07 || 10003 | Gladiator | 10004 | Király István | 1984-03-02 || 10004 | Gladiator | 10006 | Vörös Piroska | 1989-02-07 || 10005 | The English Patient | 10005 | Fehér Barna | 1990-05-18 || 10006 | Kandi Kamera+ | 10006 | Vörös Piroska | 1989-02-07 || 10007 | A botkormányos 2. | 10002 | Kiss Károly | 1978-03-02 || 10007 | A botkormányos 2. | 10013 | Johnny B. Good | 1978-03-02 || 10008 | Le Dernier Combat | NULL | NULL | NULL || 10009 | Atlantis | 10013 | Johnny B. Good | 1978-03-02 || 10010 | Subway | 10013 | Johnny B. Good | 1978-03-02 || 10011 | Le Grande Bleu | 10014 | Kovács I. Béla | 1994-03-02 || 10012 | Nikita | NULL | NULL | NULL || 10013 | Leon | 10012 | Conan O'Bryan | 1992-08-02 || 10014 | Fifth Element | NULL | NULL | NULL || 10015 | Jeanne d'Arc | NULL | NULL | NULL || 10016 | Le Transporteur | 10016 | Al Bundy | 1993-03-02 |+---------+-------------------------------------+----------+------------------+-------------+