INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Leonardo', 'Da Vinci', 'Renaissance', 'Italy', 'scientist, mathematician, engineer, inventor, anatomist, painter, sculptor, architect, botanist, musician and writer.', '1452-04-15', '1519-05-02');INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Michelangelo', 'Buonarotti', 'Renaissance', 'Italy', 'painter, sculptor, architect, poet and engineer', '1475-03-06', '1564-02-18'); INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Dominikos', 'Theotokopoulos', 'Renaissance', 'Spain', 'painter, sculptor, and architect', '1541-1-1', '1614-04-07');INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Pablo', 'Picasso', '20th century', 'Italy', 'painter and sculptor, cubism', '1881-10-25', '1973-04-08');INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Salvador', 'Dali', '20th century', 'Spain', 'Spanish surrealist painter', '1904-05-11', '1989-01-23');INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Claud', 'Monet', '19th century', 'France', 'Impressionist painter', '1840-11-14', '1926-12-05'); INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Auguste', 'Rodin', '19th century', 'France', 'Modern Sculptor', '1840-10-12', '1917-10-17'); INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Vincent', 'Van Gogh', '19th century', 'Holland', 'Post-impresionist painter', '1853-03-30', '1890-07-29');INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Federico', 'Barroci', '16th century', 'Italy', 'Baroque Painter', '1552-03-12', '1612-02-10');INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Peter', 'Rubens', '16th century', 'Germany', 'Baroque Painter', '1557-06-24', '1640-05-30');INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn) VALUES ('Aggelos','Kakomoiris','Sugxronos','Greece','Anerxomenos kallitexnis','1970-05-10');--SELECT * FROM artistINSERT INTO syllogh (syl_onoma,syl_perigrafh) VALUES ('Monimh syllogh', 'This collection features works of renowed artists from all over the world.');INSERT INTO syllogh (syl_onoma,syl_perigrafh) VALUES ('16th century', 'This collection features works of artists of the 16th Century.');INSERT INTO syllogh (syl_onoma,syl_perigrafh) VALUES ('Michelangelo', 'This collection features works of Buonarotti');INSERT INTO syllogh (syl_onoma,syl_perigrafh) VALUES ('New','This collection features the latest addition of the LUA LUA collection');--da vinciINSERT INTO antik (at_styl,at_perigrafh, at_titlos, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('mparok','Mona Lisa, or La Gioconda (La Joconde) is a 16th-century portrait painted in oil on a poplar panel by Leonardo Da Vinci during the Italian Renaissance. It is arguably the most famous painting in the world.', 'Mona Lisa', 'TRUE', 'FALSE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='Syllogh Leonardo Da Vinci')); --to exw daneistei kai to exw stin ekthesiINSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'Mona Lisa'), 'aristourgima', 'periplokh');INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'Mona Lisa'), (SELECT art_kwdikos FROM artist WHERE art_eponymo = 'Da Vinci'), '1506'); --el grecoINSERT INTO antik (at_styl,at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('mparok','The Assumption of the Virgin (15771579, oil on canvas, 401 228 cm, Art Institute of Chicago) was one of the nine paintings El Greco completed for the church of Santo Domingo el Antiguo in Toledo, his first commission in Spain.', 'THe Assumption of the Virgin','Oil on canvas','Spain', 'Renaissance', '401', '228', 'FALSE', 'TRUE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='Monimh syllogh'));INSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'THe Assumption of the Virgin'), 'relegious', 'renaissance');INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROm antik WHERE at_titlos = 'THe Assumption of the Virgin'), (SELECT art_kwdikos FROM artist WHERE art_eponymo = 'Theotokopoulos'), '1579' );--van goghINSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('The portraits were painted in Auvers-sur-Oise close to Paris, and depict Doctor Paul Gachet with a foxglove plant. Gachet took care of van Gogh during the artist''s last months. Gachet was a hobby painter and became good friends with van Gogh.', 'Portrait of Dr. Gachet', 'Oil on canvas', 'Holland', 'Post-Renaissance', '67', '56', 'FALSE', 'FALSE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='Anadromikh Van Gogh, MOMA')); --to daneisa sto moma gia dikia tou ekthesiINSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'Portrait of Dr. Gachet'), 'portrait', 'modern'); INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'Portrait of Dr. Gachet'), (SELECT art_kwdikos FROM artist WHERE art_eponymo = 'Van Gogh'), '1890');--picasso--evala ektith FALSE gia na dokimaso kaiti na to 3analla3oumeINSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('Guernica is a painting by Pablo Picasso, depicting the Nazi German bombing of Guernica, Spain, by twenty-eight bombers, on April 26, 1937 during the Spanish Civil War. The attack killed between 250 and 1,600 people, and many more were injured.', 'Guernica', 'Oil on canvas', 'Spain', 'Cubism', '349', '776', 'FALSE', 'TRUE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='Monimh syllogh'));INSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'Guernica'), 'scenery', 'modern');INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Guernica'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Picasso'),'1937');INSERT INTO antik (at_styl,at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('mparok','Les Demoiselles d Avignon (The Young Ladies of Avignon in English) is a celebrated painting by Pablo Picasso that depicts five prostitutes in a brothel, in Avignon Street in Barcelona, though, as usual with Picasso, the name was not given it until well after completion.', 'The Young Ladies of Avignon', 'Oil on canvas', 'Spain', 'Cubism', '243', '233', 'FALSE', 'TRUE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='Monimh syllogh'));INSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'The Young Ladies of Avignon'), 'portrait', 'modern');INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Young Ladies of Avignon'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Picasso'),'1937');--daliINSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('La persistencia de la memoria (1931) or The Persistence of Memory is the most famous painting by artist Salvador Dal. The painting has also been popularly known as Soft Watches, Droopy Watches, The Persistence of Time or Melting Clocks. It has been owned by the Museum of Modern Art (MoMA) in New York City since 1934. It is, however, currently on display at the Salvador Dal Museum, in St. Petersburg, Florida, (February 1June 1, 2008). The Persistence of Memory will return to Museum of Modern Art in June 2008 as part of the exhibition Dal and Film, on view June 29September 15, 2008.', 'The Persistence of Memory', 'Oil on canvas', 'Spain', 'Modern', '24', '33', 'FALSE', 'FALSE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='Monimh syllogh'));INSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'The Persistence of Memory'), 'abstract', 'surrealistic');INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Persistence of Memory'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Dali'),'1931');--rodinINSERT INTO antik (at_styl,at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_paxos, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('mparok','The Thinker (French: Le Penseur) is a bronze and marble sculpture by Auguste Rodin, held in the Muse Rodin, in Paris. It depicts a man in sober meditation battling with a powerful internal struggle. It is often used to represent philosophy.', 'The Thinker', 'Bronze Statue', 'France', 'Modern', '1', '2', '3', 'FALSE', 'FALSE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='Monimh syllogh'));INSERT INTO filot_apo (fa_at_kwdikos,fa_art_kwdik,fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Thinker'), (SELECT art_kwdikos FROM artist WHERE art_eponymo='Rodin'),'1937');INSERT INTO glypto (gl_at_kwdikos,gl_texnotr,gl_is_statue) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Thinker'), 'Modern', 'TRUE');--BarocciINSERT INTO antik (at_styl,at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('mparok', 'Oil on canvas, Santa Maria degli Angeli, Perugia', 'Annunciation', 'Canvas', 'Italy', '16th Century', 'TRUE', 'TRUE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='16th century'));INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Annunciation'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Barroci'),'1592');INSERT INTO pinakas (pin_at_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Annuciation'));INSERT INTO antik (at_styl,at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('mparok', 'oil on canvas, Madrid', 'The Nativity', 'Canvas', 'Spain', '16th Century', 'FALSE', 'TRUE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='Monimh syllogh'));INSERT INTO pinakas (pin_at_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Nativity'));INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Nativity'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Barroci'),'1597');INSERT INTO antik (at_styl,at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('mparok', 'Portrait', 'Francisco II della Rovere', 'Canvas', 'Italy', '16th Century', 'FALSE', 'FALSE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='16th century'));INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos= 'Francisco II della Rovere'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Barroci'),'1572');INSERT INTO pinakas (pin_at_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Francisco II della Rovere'));INSERT INTO antik (at_styl,at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('mparok', '1,050 729 pixels, file size: 119 KB, MIME type: image/jpeg', 'Aeneas Flight from Troy', 'Canvas', 'Italy', '16th Century', 'FALSE', 'TRUE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='16th century'));INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos= 'Aeneas Flight from Troy'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Barroci'),'1598');--RubensINSERT INTO antik (at_styl,at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('mparok', 'Self-Portrait', 'Rubens and Isabella Brant', 'Canvas', 'Germany', '16th Century', 'FALSE', 'FALSE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='16th century'));INSERT INTO pinakas (pin_at_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Rubens and Isabella Brant'));INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos= 'Rubens and Isabella Brant'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Rubens'),'1609');INSERT INTO antik (at_styl,at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('mparok', 'Painted during Rubens first trip to Spain in 1603', 'Equestrian Portrait of Duke of Lerma', 'Canvas', 'Spain', '16th Century', 'FALSE', 'FALSE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='16th century'));INSERT INTO pinakas (pin_at_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Equestrian Portrait of Duke of Lerma'));INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Equestrian Portrait of Duke of Lerma'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Rubens'),'1603');--BuonarottiINSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ( 'Saint Bartholomew is shown holding the knife of his martyrdom', 'The Last Judgment', 'Canvas', 'Italy', 'Renaissance', 'FALSE', 'TRUE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='Michelangelo'));INSERT INTO pinakas (pin_at_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Last Judgment'));INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Last Judgment'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Buonarotti'),'1541');INSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ( 'Painting', 'The Libyan Sybil', 'Canvas', 'Italy', 'Renaissance', 'FALSE', 'TRUE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='Michelangelo'));INSERT INTO pinakas (pin_at_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Libyan Sybil'));INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Libyan Sybil'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Buonarotti'),'1522');INSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ( 'ceiling of the Sistine Chapel', 'Sistine Chapel', 'Wall', 'Italy', 'Renaissance', 'FALSE', 'FALSE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='Michelangelo'));INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Sistine Chapel'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Buonarotti'),'1512');INSERT INTO allo (allo_at_kwdikos,allo_typos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Sistine Chapel'),'toixografia');--MonetINSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ( 'Impression, soleil levant', 'Sunrise', 'Canvas', 'France', '19th Century', 'FALSE', 'FALSE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='New'));INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Sunrise'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Monet'),'1872');INSERT INTO pinakas (pin_at_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Sunrise'));INSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_daneiko, at_se_ekthesh, at_kwd_syl) VALUES ('Yellow Nirwana', 'Sea-Roses', 'Canvas', 'France', '20th Century', 'FALSE', 'FALSE', (SELECT syl_kwd_syl FROM syllogh WHERE syl_onoma='New'));INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Sea-Roses'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Monet'),'1920');INSERT INTO pinakas (pin_at_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Sea-Roses'));--kafrilano1:UPDATE antik SET at_daneiko='FALSE';UPDATE antik SET at_se_ekthesh='FALSE';--SELECT * FROM antik;--SELECT * FROM pinakas;--SELECT * FROM filot_apo;--SELECT * FROM glypto;INSERT INTO ekthesi (ekth_onoma,ekth_thema,ekth_ticket,ekth_visitors,ekth_im_enarks,ekth_im_liks) VALUES ('O Picasso synomilei me ton Leonardo Da Vinci', 'This is a retrospective display of Picasso and Leonardo Da Vinci', '5', '14000', '2008-01-01', '2008-02-15');INSERT INTO ekthesi (ekth_onoma,ekth_thema,ekth_ticket,ekth_visitors,ekth_im_enarks,ekth_im_liks) VALUES ('H anagennisi','Ta simamtikotera erga tis anagennisis','8','1100','2008-02-01','2008-06-01');INSERT INTO ekthesi (ekth_onoma,ekth_thema,ekth_ticket,ekth_visitors,ekth_im_enarks,ekth_im_liks) VALUES ('Greek artists', 'Ellines kallitexnes','3','800','2007-09-01','2008-07-31');INSERT INTO ekthesi (ekth_onoma,ekth_thema,ekth_ticket,ekth_visitors,ekth_im_enarks,ekth_im_liks) VALUES ('o 16os aiwnas', 'ta simantikotera erga tou 16ou aiwna','10','0','2008-03-01','2008-05-01');--SELECT * FROM ekthesi;--ekthesi picassoINSERT INTO ektith (ekth_at_kwdikos,ekth_ekth_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Guernica'), (SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='O Picasso synomilei me ton Leonardo Da Vinci'));INSERT INTO ektith (ekth_at_kwdikos,ekth_ekth_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Young Ladies of Avignon'), (SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='O Picasso synomilei me ton Leonardo Da Vinci'));--ekthesi anaggenisiINSERT INTO ektith (ekth_at_kwdikos,ekth_ekth_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Last Judgment'), (SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='H anagennisi'));INSERT INTO ektith (ekth_at_kwdikos,ekth_ekth_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Libyan Sybil'), (SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='H anagennisi'));--ekthesi ellinesINSERT INTO ektith (ekth_at_kwdikos,ekth_ekth_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='THe Assumption of the Virgin'), (SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='Greek artists'));--ekthesi 16osINSERT INTO ektith (ekth_at_kwdikos,ekth_ekth_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Annunciation'), (SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='o 16os aiwnas'));INSERT INTO ektith (ekth_at_kwdikos,ekth_ekth_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Nativity'), (SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='o 16os aiwnas'));INSERT INTO ektith (ekth_at_kwdikos,ekth_ekth_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Aeneas Flight from Troy'), (SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='o 16os aiwnas'));--SELECT * FROM ektith;UPDATE antik SET at_se_ekthesh='TRUE' WHERE at_kwdikos in (SELECT ekth_at_kwdikos FROM ektith);--mmeINSERT INTO meso (mes_onoma,mes_typos) VALUES ('ET1', 'TV');INSERT INTO meso (mes_onoma,mes_typos) VALUES ('www.texnh.gr','internet');INSERT INTO meso (mes_onoma,mes_typos) VALUES ('proto thema', 'efimerida');INSERT INTO meso (mes_onoma,mes_typos) VALUES ('ta nea', 'efimerida');INSERT INTO meso (mes_onoma,mes_typos) VALUES ('www.galleries.gr', 'internet');INSERT INTO meso (mes_onoma,mes_typos) VALUES ('flash 96','radio');--diafimistikes kampaniesINSERT INTO diafimisi (diaf_ekth_kwdik,diaf_mes_kwdik,diaf_date,diaf_kostos) VALUES ((SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='O Picasso synomilei me ton Leonardo Da Vinci'), (SELECT mes_kwdikos FROM meso WHERE mes_onoma='ET1'), '2007-01-15', '10000');INSERT INTO diafimisi (diaf_ekth_kwdik,diaf_mes_kwdik,diaf_date,diaf_kostos) VALUES ((SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='H anagennisi'), (SELECT mes_kwdikos FROM meso WHERE mes_onoma='proto thema'), '2007-02-20','50000');INSERT INTO diafimisi (diaf_ekth_kwdik,diaf_mes_kwdik,diaf_date,diaf_kostos) VALUES ((SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='o 16os aiwnas'), (SELECT mes_kwdikos FROM meso WHERE mes_onoma='ta nea'), '2007-02-20','30000');INSERT INTO diafimisi (diaf_ekth_kwdik,diaf_mes_kwdik,diaf_date,diaf_kostos) VALUES ((SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='O Picasso synomilei me ton Leonardo Da Vinci'), (SELECT mes_kwdikos FROM meso WHERE mes_onoma='www.texnh.gr'), '2007-02-22','5000000');INSERT INTO diafimisi (diaf_ekth_kwdik,diaf_mes_kwdik,diaf_date,diaf_kostos) VALUES ((SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='Greek artists'), (SELECT mes_kwdikos FROM meso WHERE mes_onoma='flash 96'), '2007-02-22','200000');--eksoterikes sullogesINSERT INTO eks_syllogh (eks_typos,eks_on_ypefth,eks_ep_ypefth,eks_odos_yp,eks_ar_ypefth) VALUES ('Syllogh Leonardo Da Vinci','Maria', 'Papadopoulou', 'Plastira', '16');INSERT INTO eks_syllogh (eks_typos,eks_on_ypefth,eks_ep_ypefth,eks_odos_yp,eks_ar_ypefth) VALUES ('Anadromikh Van Gogh MOMA','Tania', 'Popovich', 'Plastira', '16');INSERT INTO eks_syllogh (eks_typos,eks_on_ypefth,eks_ep_ypefth,eks_odos_yp,eks_ar_ypefth) VALUES ('Syllogh Mesopotamiou meggistana','Abdoul', 'Mouhaled', 'Mesogeion', '320');INSERT INTO eks_syllogh (eks_typos,eks_on_ypefth,eks_ep_ypefth,eks_odos_yp,eks_ar_ypefth) VALUES ('Sullogh Sundesmou Filwn Texnhs','Nikos','Paxatouridis','Suggrou','100');--thlefwna upeu8unwnINSERT INTO til_ypefth (til_ep_ypefth,til_til) VALUES ('Papadopoulou', '2106456789');INSERT INTO til_ypefth (til_ep_ypefth,til_til) VALUES ('Papadopoulou', '2106456790');INSERT INTO til_ypefth (til_ep_ypefth,til_til) VALUES ('Popovich', '2230555999');INSERT INTO til_ypefth (til_ep_ypefth,til_til) VALUES ('Mouhaled', '2102102102');INSERT INTO til_ypefth (til_ep_ypefth,til_til) VALUES ('Mouhaled', '004021312');INSERT INTO til_ypefth (til_ep_ypefth,til_til) VALUES ('Paxatouridis', '210979999');--antikeimena pou exoume daneisteiINSERT INTO se_dan (se_at_kwdikos,se_eks_kwdikos,se_imer_dan,se_imer_ep) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Mona Lisa'), (SELECT eks_kwdikos FROM eks_syllogh WHERE eks_typos='Syllogh Leonardo Da Vinci'),'2007-10-12','2008-03-24');INSERT INTO se_dan (se_at_kwdikos,se_eks_kwdikos,se_imer_dan,se_imer_ep) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Annunciation'), (SELECT eks_kwdikos FROM eks_syllogh WHERE eks_typos='Syllogh Mesopotamiou meggistana'),'2008-01-10','2008-03-21');INSERT INTO se_dan (se_at_kwdikos,se_eks_kwdikos,se_imer_dan,se_imer_ep) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Last Judgment'), (SELECT eks_kwdikos FROM eks_syllogh WHERE eks_typos='Syllogh Mesopotamiou meggistana'),'2008-01-10','2008-02-21');INSERT INTO se_dan (se_at_kwdikos,se_eks_kwdikos,se_imer_dan,se_imer_ep) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Libyan Sybil'), (SELECT eks_kwdikos FROM eks_syllogh WHERE eks_typos='Sullogh Sundesmou Filwn Texnhs'),'2007-10-10','2008-04-21');UPDATE antik SET at_daneiko='TRUE' WHERE at_kwdikos IN (SELECT se_at_kwdikos FROM se_dan);--antikeimena pou exoume daneisei--INSERT INTO dan_se (dan_at_kwdikos,dan_eks_kwdikos,dan_imer_dan,dan_imer_ep) VALUES ((SELECT fa_at_kwdikos FROM filot_apo WHERE fa_art_kwdik IN (SELECT art_kwdikos FROM artist WHERE art_eponymo='Van Gogh')),(SELECT eks_kwdikos FROM eks_syllogh WHERE eks_typos='Anadromikh Van Gogh MOMA'), '2007-10-25', '2008-02-18');INSERT INTO dan_se (dan_at_kwdikos,dan_eks_kwdikos,dan_imer_dan,dan_imer_ep) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Portrait of Dr. Gachet'), (SELECT eks_kwdikos FROM eks_syllogh WHERE eks_typos='Anadromikh Van Gogh MOMA'),'2007-10-25','2008-03-22');INSERT INTO dan_se (dan_at_kwdikos,dan_eks_kwdikos,dan_imer_dan,dan_imer_ep) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Sunrise'), (SELECT eks_kwdikos FROM eks_syllogh WHERE eks_typos='Syllogh Mesopotamiou meggistana'),'2007-09-25','2008-04-20');INSERT INTO dan_se (dan_at_kwdikos,dan_eks_kwdikos,dan_imer_dan,dan_imer_ep) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Sea-Roses'), (SELECT eks_kwdikos FROM eks_syllogh WHERE eks_typos='Sullogh Sundesmou Filwn Texnhs'),'2008-02-25','2008-05-01');INSERT INTO dan_se (dan_at_kwdikos,dan_eks_kwdikos,dan_imer_dan,dan_imer_ep) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Rubens and Isabella Brant'), (SELECT eks_kwdikos FROM eks_syllogh WHERE eks_typos='Sullogh Sundesmou Filwn Texnhs'),'2008-03-10','2008-03-30');INSERT INTO dan_se (dan_at_kwdikos,dan_eks_kwdikos,dan_imer_dan,dan_imer_ep) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Thinker'), (SELECT eks_kwdikos FROM eks_syllogh WHERE eks_typos='Syllogh Mesopotamiou meggistana'),'2008-01-10','2008-02-15');